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

Report message to a moderator

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: 68728
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 10:15:09 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.