Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: import ignore primary key
Thanks for both responses. They were very helpful.
Steve
On Tue, 20 Jun 2000 19:37:21 +0800, Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:
>Steve . wrote:
>>
>> I exported the entire database, and also just the user level export.
>>
>> The scripts form the software company we are using, creates a unique
>> primary key each time you run them. Kind of makes it hard to do your
>> own replication.
>>
>> Two questions:
>>
>> 1. Can you see what the primary key is in the dump file?
>>
>> 2. The company that gave us the original scripts, has a program to
>> export into a new database, just the data in the tables. I want to
>> import the dump back into the original database to try their
>> replication scripts. If I do an import using imp, and it keeps
>> complaining about the primary key on the row, will all the data still
>> import into the database so I can run their own scripts to move the
>> data to a new database?
>>
>> If not, how is the best way to make sure all the data gets put in? Do
>> I need to wipe all the tables and let the import recreate them for the
>> user? Thanks.
>>
>> Steve
>>
>> Newsgroup replies preferred. Remove nospam when replying thru email.
>
>exp constraints=n
>
>will give you an export without the PK's so you can import just the
>table data.
>
>Or use imp indexfile=xxx.sql. The resultant file will contain ALL the
>DDL (all bar the indexes being commented out). You can extract from
>this the CREATE TABLE commands, run them through, import just the tables
>etc etc
>
>HTH
Received on Wed Jun 21 2000 - 00:00:00 CDT