From: "Bob Fazio" <rfazio@home.com.nospam>
Subject: Re: How to do a full import?
Date: 2000/06/06
Message-ID: <5cZ_4.234758$Tn4.2123634@news1.rdc2.pa.home.com>#1/1
References: <idU_4.2548$ch3.4628@news11-gui.server.ntli.net>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Complaints-To: abuse@home.net
X-Trace: news1.rdc2.pa.home.com 960257921 24.8.218.197 (Mon, 05 Jun 2000 19:18:41 PDT)
Organization: @Home Network
X-MSMail-Priority: Normal
Reply-To: "Bob Fazio" <rfazio@home.com.nospam>
NNTP-Posting-Date: Mon, 05 Jun 2000 19:18:41 PDT
Newsgroups: comp.databases.oracle.server


You have to re-create the database , and then run the import.  Refer to the
documentation on import.

--
Robert Fazio, Oracle DBA
rfazio@home.com
remove nospam from reply address
http://24.8.218.197/
"Guy Fullalove" <nospam@127.0.0.1> wrote in message
news:idU_4.2548$ch3.4628@news11-gui.server.ntli.net...
> Oracle 7.3.4 on Solaris 2.6
>
> This may be a silly question, but how do you do a full import?  I have an
> export that I ran a while ago with full=y, I now want to import it back
 into
> the same database replacing the data that is currently there.  Could some
> one please give me step by step instructions as to how this can be
 achieved?
>
> I've tried just running imp full=y, on the existing DB, but I get loads of
> constraint/object errors (as expected).  If I were to disable the
> constraints, would I also have to do this for the system/sys accounts
 also?
>
> Full exports are very easy to do, but it just seems the import part is
 very
> complicated!
>
> Any help would be appreciated.
>
> Thanks
>
> --
> Guy Fullalove
> (guy.fullalove@which.net)
>
>