You have to re-create the database , and then run the import. Refer to the
documentation on import.
--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Guy Fullalove" <nospam_at_127.0.0.1> wrote in message
news:idU_4.2548$ch3.4628_at_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_at_which.net)
>
>
Received on Tue Jun 06 2000 - 00:00:00 CDT
