RE: How to import without ruin the constraints?

You should carry out the export eliminating the option constraints=n, example:

userid=x/xx
rows=y
constraints=n
.
.

With the exit of this file.dmp should care the lines, the creation of the outline should be carried out with the option constraints=n

Atte.
Larry

Chile

bgt0990 <btighe_at_neometrics.com> escribió en el mensaje de noticias 3cbebea0_4_at_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 - 08:26:21 CDT