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.
thanks
kavitha
Kavitha,
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 http://metalkink.oracle.com
or
tahiti.oracle.com and do a search of your requirements.
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.
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.
thanks
kavitha
Hi kavitha,
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.
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.
Reply With Quote
Bookmarks