Heloo friends I am a new database designer,so I am designing database for mobile website,it contains modules like customer registration,services,onlinefriends etc.
software oracle 9i,sunsolaris.
so i need to create 3 sql scripts for installation of my data at client place.
1)tables and index script
2)export and import
3)new database for this project.
any one can give sources or scripts.
If i understand your requirements correctly, you have the DATA and need to load this data in the tables and create indexes on them. And you also need some scripts for the IMPORT/EXPORT of the data.
And also you need the DATABASE, what do u actually mean by new DATABASE,, is the database is available for you or you need to create one ???
Would you be more clear of your requirements.. Anyway, for all your requirements, you can look at
tahiti.oracle.com and do a search of your requirements.
May be they help you best for the time being
i think , u have already created a database at your development site. now you have to create a the same database at your client site and import the full database.
i think thats all. no script required for creating tables and indexes as import will do it.
8i OCP DBA
HII reddy thanks for ur reply,
but present i am creating in 9i scott/tiger.
I need to create new database in sunsolaris and i will export entire tables and indexes to there.
When u say scott/tiger,u hava already created a database.What i understand from you telling is that now u need to import ur data into this database.
What u need to do is take a complete database export of ur previous database.
then import that into ur new database.This will make ur new database indentical to ur old database.
the command to export is
exp username/password@servicename file= full=yes
imp username/password@servicename file== commit=yes ignore=yes full=yes.
I guess this what u wanted.
You can get numerous DB creation sample scripts.
But as u say it is for a Site, it ought to be available 24/7.
U got to decide on various parameters based on the number of expected transactions & Hits etc.,
Follow link below... it would give u overview of creating a Database.
Search the archive for more info.,
Never give up !
Nanda Kumar - Vellore
Click Here to Expand Forum to Full Width