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 http://metalkink.oracle.com
tahiti.oracle.com and do a search of your requirements.
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.