Home » RDBMS Server » Server Administration » Generate ddl for all sequences in the database (starting with 1) (sles 9, oracle 10g)
Generate ddl for all sequences in the database (starting with 1) [message #360347] Thu, 20 November 2008 09:58 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 20:48:30 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.