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

[dist cash]

Thank you for your answer.  The proble I have is NOT export.  I checked 
export log and found "sequence" actually export, but on import (user mode) 
it did NOT create 'sequence".




>From: "Deshpande, Kirti" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: [Q] how to export "sequence number"?
>Date: Wed, 19 Dec 2001 17:15:35 -0800
>
>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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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).




_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dist cash
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

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

[Deshpande, Kirti]

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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).