Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help importing / exporting a schema

Re: Need help importing / exporting a schema

From: <sybrandb_at_hccnet.nl>
Date: Sun, 03 Jun 2007 15:59:57 +0200
Message-ID: <h8i563511t7dcn2isi97t09oa9e5p80270@4ax.com>


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 DBA
Received on Sun Jun 03 2007 - 08:59:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US