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
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: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
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
Previous Topic: Compatibility - Solaris 10 with Oracle7+forms
Next Topic: oracle job is broken
Goto Forum:
  


Current Time: Sat Dec 03 14:26:43 CST 2016

Total time taken to generate the page: 0.06531 seconds