Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to import without ruin the constraints?
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