Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
impdp overwrite 2
- Thread starter ClaireHCM
- Start date
-
1
- #2
SantaMufasa
Technical User
Claire,
If you have access to DBA privileges, my choice before importing (either Classic or DataPump) is to simply "DROP USER <target user> CASCADE;", then re-create the user.
One can certainly run a script to DROP all objects in the schema, as well, but I prefer the "quick-and-clean" method.![[smile]](/data/assets/smilies/smile.gif "[smile] [smile]")
Let us know if you have follow-on questions.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
If you have access to DBA privileges, my choice before importing (either Classic or DataPump) is to simply "DROP USER <target user> CASCADE;", then re-create the user.
One can certainly run a script to DROP all objects in the schema, as well, but I prefer the "quick-and-clean" method.
Let us know if you have follow-on questions.
Mufasa(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
-
1
- #3
tekdudedude
Technical User
- Sep 29, 2007
- 79
ClaireHCM,
You may wish to look at the Table Exists Action (TEA). The default is to replace if the object exists.
TD
You may wish to look at the Table Exists Action (TEA). The default is to replace if the object exists.
TD
- Thread starter
- #4
SantaMufasa
Technical User
Claire,
I recommend your checking into/Googling TekDudeDude's suggestion for specifying Table Exists Action.
I that does not seem to meet your needs, you can use whatever administrative tool you have to DROP the objects that the schema owns prior to your import/data pump.
Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
I recommend your checking into/Googling TekDudeDude's suggestion for specifying Table Exists Action.
I that does not seem to meet your needs, you can use whatever administrative tool you have to DROP the objects that the schema owns prior to your import/data pump.
Mufasa(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
- Status