Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help importing / exporting a schema
On Sun, 3 Jun 2007 13:14:13 GMT, "Blake McBride" <blake_at_mcbride.name>
wrote:
>
>I presume using "DROP USER" is only half of what I need.
>Don't I have to re-add the user or schema?
depends on the kind of export/import.
Only a full database export will contain all create user commands
Only a full database import will read those and execute them.
-- Sybrand Bakker Senior Oracle DBAReceived on Sun Jun 03 2007 - 08:59:57 CDT