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: Duplicate database to personal oracle

Re: Duplicate database to personal oracle

From: BLANC Philippe <blancphi_at_club-internet.fr>
Date: Sun, 27 Feb 2000 20:26:40 +0100
Message-ID: <951680855.637258010@news.club-internet.fr>


Le ven, 25 fév 2000, MikeB a écrit :
>Hi
>
>I'd like to create a complete copy of my network database on personal
>oracle on my machine.
>
>I've tried Export and Import but it seems to fill the tables in
>alphabetical order so I get Primary/Foreign key relationships failing
>and the whole database is not built correctly.
>
>Currently we're using Oracle 7.3.?
>
>Hope someone can help
>Thanks
>
>--
>Mike Ball
>MCI WorldCom
>UK
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

you have to export one user , then owner of the object (table, stored proc ...) After import this user in your personal database Received on Sun Feb 27 2000 - 13:26:40 CST

Original text of this message

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