Only import sequences?
I fully exported a db.
I only import 1 user. But I made a mistake: I dropped the tables, but forgot to drop the sequences.
Oracle documentation says:
If sequence numbers need to be reset to the value in an export file as part of an import, you should drop sequences. A sequence that is not dropped before the import is not set to the value captured in the export file, because Import does not drop and re-create a sequence that already exists. If the sequence already exists, the export file's CREATE SEQUENCE statement fails and the sequence is not imported.
Now, old sequences are used, with wrong values.
Can I drop the sequences and import them seperately, without importing something else?
Help is highly appreciated!
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
Click Here to Expand Forum to Full Width