import question

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 Fri Aug 20 1999 - 18:54:03 CDT