OraFAQ Forum: Server Administration » Generate ddl for all sequences in the database (starting with 1)

Home » RDBMS Server » Server Administration » Generate ddl for all sequences in the database (starting with 1) (sles 9, oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Generate ddl for all sequences in the database (starting with 1) [message #360347]

Thu, 20 November 2008 09:58

dirkm
Messages: 86
Registered: November 2008
Location: Centurion - South Africa

Member

Is it possible to generate a script that contains all the sequences in an existing database, but starting with 1 (for example for deployment to a new client that will start with a fresh database) ?

Create sequence .....
Start with 1

Dirk

Report message to a moderator

Re: Generate ddl for all sequences in the database (starting with 1) [message #360350 is a reply to message #360347]

Thu, 20 November 2008 10:37

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes.

Regards
Michel

Report message to a moderator

Re: Generate ddl for all sequences in the database (starting with 1) [message #361243 is a reply to message #360347]

Tue, 25 November 2008 08:49

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Either export the whole database, or use DBMS_METADATA

Report message to a moderator

Previous Topic:	Compatibility - Solaris 10 with Oracle7+forms
Next Topic:	oracle job is broken

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 07:24:04 CDT 2025