RE: [Q] how to export "sequence number"?

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Wed, 19 Dec 2001 17:41:35 -0800
Message-ID: <F001.003E0D23.20011219171534@fatcity.com>

Oracle exports sequences in the full or user(e.g. owner=scott)level exports. I would run 'strings' command to scan the dump file to make sure the sequences are there (strings exp.dmp | grep -i sequence). If those are not there, then the export was probably done at table level. If the sequence was owned by "user1" at the time of export, and export was done at "user" level, and the sequence is still missing in the dump file(not shown by 'strings'), then I would consider creating an iTAR with Oracle Support.

Kirti

-----Original Message-----
Sent: Wednesday, December 19, 2001 8:10 AM To: Multiple recipients of list ORACLE-L

We have ORACLE 8i running on UNIX server. I export from "user1" and import to "user2". I found everything look correct except "sequence number" not in their. Does their has way to export "sequence number"?

Thanks.

_
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Dec 19 2001 - 19:41:35 CST