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: import ignore primary key

Re: import ignore primary key

From: Steve . <syarbrou_at_enteract.com>
Date: 2000/06/21
Message-ID: <mi62lsk8batedrq2mpg66p5h8n6occdakf@4ax.com>#1/1

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

Original text of this message

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