-
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
-
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.
May be they help you best for the time being
--Reddy
-
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.
Santosh Jadhav
8i OCP DBA
-
newdatabase
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
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.
the command to export is
exp username/password@servicename file= full=yes
to import
imp username/password@servicename file== commit=yes ignore=yes full=yes.
I guess this what u wanted.
regards
anandkl
anandkl
-
Hi Kavitha,
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.
http://www.dbasupport.com/oracle/ora...createDB.shtml
Search the archive for more info.,
Cheers
Nandu
Never give up !
Nanda Kumar - Vellore
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|