Re: import question

check for triggers on the table which do a select on a sequence. If this is the case
the current value of the sequence will be exported and thus imported.

Simply reset the sequence before dropping it.

alter sequence sequence_name
start value whatever_you_want
/

user user_sequences to find the sequence name and parameters.

Dan
kiss <kiss_at_yahoo.com> wrote in message news:37BDEA9B.238807E8_at_yahoo.com...
> Hi, we are using Oracle 8.0.5 on Solaris 2.7.
>
> We basically had a fresh copy of data that needed to be imported from
> the development database to the soon to be production database.
>
> In order to try to have clean data, I truncated all tables on the
> production database for the particular schema that was going to be
> imported.
>
> I then took the dump file from the development machine (schema export)
> and specified imp user/password File=exp.dmp Full=Y Ignore=Y Log=imp.log
>
> Everything appeared to be fine.
>
> However, when taking a look at the data, all tables with an ID field
> (which was the primary key), were renumbered in their sequences.
> Example, instead of starting the ID numbers with 1, they renumbered
> themselves as the next number from the last ID number within the export
> file.....
> So a table beginning with ID of 1 and ending with ID of 100 on
> development(exported data) was now seen as beginning with ID of 101 on
> the Production box.
>
> Did I do something wrong here?
>
> Thanks.
>
Received on Sat Aug 21 1999 - 10:05:16 CDT