Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to import without ruin the constraints?

Re: How to import without ruin the constraints?

From: bgt0990 <btighe_at_neometrics.com>
Date: Thu, 18 Apr 2002 08:36:27 -0400
Message-ID: <3cbebea0_4@corp-news.newsgroups.com>


imp user/pass file=whatever.dmp ignore=y fromuser=scott touser=scott

That should be all you need. You can't use "tables=" and fromuser/touser together.

"Katarina Amender" <katta.klos_at_home.se> wrote in message news:df2d2fc9.0204180355.e23b7ea_at_posting.google.com...
> Hi there!
>
> I have a major problem!
>
> I have created a copy of my database on the same server. Now I have a
> copy which contains all the tables, definitions, users, indexes and so
> on but no actual data. What I want to do now is to import the rows in
> all tables from an export dump.
>
> How do I do an import to my new database without ruin the constraints?
> I have tried to use the following for import:
>
> userid=aaa/111_at_test
> file=c:\dumpfile.dmp
> fromuser=scott
> touser=scott
> tables=(*)
> rows=y
> ignore=y
>
> Can anyone tell me whats wrong??
>
> Using 8.1.5 on NT4
>
> regards// Katta
Received on Thu Apr 18 2002 - 07:36:27 CDT

Original text of this message

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