|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
August 6th, 2004, 06:44 AM
|
|||
|
|||
|
re:thnx shafique ,jim 1 more doubt
hi there,
To create a database, making it available for general use. This statement erases all data in any specified datafiles that already exist in order to prepare them for initial database use. If you use the statement on an existing database, all data in the datafiles is lost. the above is an extract from the oracle doc.what i wanted to ask is if i have already have a database and have some objects in it.will creating a new database delete all data? plz enlighten me regarding this. regards, ds
|
|
#2
August 6th, 2004, 09:47 AM
|
|||
|
|||
|
Your user's schema will be lost, if that's what you want to know.
Edit: You can exp a user's schema, then imp it into a newly initialized db. This gives you a 'no data' version of the database. Last edited by jim mcnamara : August 6th, 2004 at 10:41 AM. Reason: add exp
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > re:thnx shafique ,jim 1 more doubt |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
