Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: HELP please - Import Of Sequences ONLY - THANKS
Imported with SHOW=Y , whereby the LOG file Got populated with the Required
Sequence Creation SQL Scripts Containing Respective Latest Data Values of
the Sequences
Ran these SQL scripts thereafter
Rahul - Thanks for the Advice . Though need to check it out Gopi - Sorry for the confusion . The Required Sequences are Application Specific User Created Sequences (NOT those of SYS)
> -----Original Message-----
> From: Rahul [SMTP:rahul_at_ratelindo.co.id]
> Sent: Tuesday, August 08, 2000 1:13 PM
> To: VIVEK_SHARMA
> Subject: RE: HELP please - Import Of Sequences ONLY
>
> you have to import without the tables clause,
> as the tables are created errors will be returned and
> in the end, all the other objects(views/functions/sequences) will be
> imported..
>
-----Original Message----- From: Gopi Chand Telukoti [SMTP:tgopichand_at_visto.com] Sent: Tuesday, August 08, 2000 1:40 PM To: VIVEK_SHARMA Subject: Re: HELP please - Import Of Sequences ONLY Hi Vivek, Is the sequences are SYS Objects or temporary tables? If they are SYS Objects please recreate. Else find the temo tables and see wether they are imported or not?Import the same.
Gopi
> > ----------
> > From: VIVEK_SHARMA[SMTP:vivek_sharma_at_inf.com]
> > Sent: Tuesday, August 08, 2000 1:35 PM
> > To: 'oracledba_at_quickdoc.co.uk'; 'ORACLE-L_at_fatcity.com'
> > Subject: HELP please - Import Of Sequences ONLY
> >
> >
> > After Importing from an Export Dump into an NEWly Created Database
> > by Specifying the individual TABLE Names (TABLES parameter) ,
> > NO Sequences have Got imported
> >
> > How can the Sequences be imported/Obtained from the Export Dump ?
> >
> >
> >
> > --------
> > If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> > to unsubscribe, send a blank email to
> oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
Received on Tue Aug 08 2000 - 03:40:39 CDT