Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help importing / exporting a schema
On 3-Jun-2007, sybrandb_at_hccnet.nl wrote:
> 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.
>
I would rather the import / export exclude creation of users. I'd rather it only deal with tables, indexes, etc.
So, what commends would you recommend for the balnking of the database?
Any ideas about getting the kink of export I am looking for? (If the export includes user creation, it is okay. I can ignore those commands.)
Thanks.
Blake McBride Received on Sun Jun 03 2007 - 09:14:10 CDT