| Full Import - Quick Question [message #73615] |
Wed, 02 June 2004 14:16  |
Troy
Messages: 10
Registered: October 2000
|
Junior Member |
|
|
When we do a full import of a full export into a database, does it overwrite the existing objects or does it try to append the data?
Thanks
|
|
|
|
| Re: Full Import - Quick Question [message #73622 is a reply to message #73615] |
Sun, 06 June 2004 04:49  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
It will normally try to append. Therefore, you need to drop/truncate all objects before doing the import.
If you don't like this behaviour, look at the DESTROY option (overwrite tablespace data files). Nevertheless, this is VERY DANGEROUS, and should be left to the senior DBA's.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
