Home » RDBMS Server » Server Utilities » exporting table and the sequence associated
icon9.gif  exporting table and the sequence associated [message #260127] Fri, 17 August 2007 09:25 Go to next message
vicfardall
Messages: 1
Registered: August 2007
Location: Brasília
Junior Member
Hi everybody !
I need a big help.... I need to export one table from one instance to another, the table is associated with one sequence, how I import the table as it was created and populated (with the sequence...)
Many many thanks in advance...

Victoria
Re: exporting table and the sequence associated [message #260152 is a reply to message #260127] Fri, 17 August 2007 10:55 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
the table is associated with one sequence

There is no association between a table and a sequence in Oracle.
It is a logical thing you built.

You have to manually recreate your sequence at target db starting with the last number in your source db.

Regards
Michel
Previous Topic: help needed with sqlldr
Next Topic: Ssql*Loader - Ignoring certain columns while loading
Goto Forum:
  


Current Time: Tue Dec 03 12:13:38 CST 2024