On Tue, 9 Feb 1999, Mandalika Sankar wrote:

> Hi,
>   I would like to know if I do a full export from one database (db1)
>   and do a full import into another database (db2), are the sequences
>   automatically generated on db2? If so, how can I check them? I tried
>   the DUAL table but did not find any useful information in there.
> Thanks in advance,
> Sankar.
>
Sankar,

Yes, the sequences do get generated on db2. To check the sequences, issue:

SELECT * FROM DBA_SEQUENCES;

or

SELECT * FROM ALL_SEQUENCES;

To find the next value of a sequence, issue:

SELECT sequence_name.NEXTVAL from DUAL;

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 250+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page to Ari Kaplan's Home Page