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: Oh plz help me with imp/exp

Re: Oh plz help me with imp/exp

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Fri, 19 Mar 1999 21:52:00 -0500
Message-ID: <7cv2dd$i56$1@winter.news.rcn.net>


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

Original text of this message

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