RE: HELP please - Import Of Sequences ONLY - THANKS

From: VIVEK_SHARMA <vivek_sharma_at_inf.com>
Date: Tue, 8 Aug 2000 14:10:39 +0530
Message-Id: <10583.114042@fatcity.com>

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