Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oh plz help me with imp/exp
Hi John,
From what I recall you have to have the database instance and tablespaces built before you do the import. I am at home and my documentation is at work so I can't check the Utilities manual which contains the answer.
regards
Jerry Gitomer
John Matzen wrote in message <36F28164.6A2BE06E_at_ausa.net>...
>The problem I seem to be having is that I do a full export like this:
>
>exp full=y
>
>this seems to do the export job, but when I try to import into a newly
>created database system the imp:
>
>imp full=y
>
>does not import the users, and as a result doesn't import the users'
>tables and other things. Now, as far as I can tell, according to the
>"book" I have (Oracle8 DBA Handbook) this is supposed to import the
>users.
>
>So, anyway, I created a user manually to do some testing it doesn't
>create the tablespaces either even when I do a
>
>imp full=y destroy=y
>
>I'm a little confused here!!
>
>Thanks,
>
>John Matzen
>
>
Received on Fri Mar 19 1999 - 20:52:00 CST
![]() |
![]() |