| Database Schema [message #382269] |
Wed, 21 January 2009 11:07  |
danyromimd
Messages: 73
Registered: August 2008
|
Member |
|
|
Hi all!!
Is there anything in oracle such as Informix "dbschema" which writes a sql script than can be later used to create the whole database with its tables, indexes, views, stored procedures and triggers?
Thanks in advance,
Daniela.
|
|
|
|
|
|
| Re: Database Schema [message #382272 is a reply to message #382269] |
Wed, 21 January 2009 11:28  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>Is there anything in oracle such as Informix "dbschema"
Not really.
Depending upon actual requirements; some possible alternatives exist.
DBMS_METADATA
exp rows=no owner=schema_name
above will "capture" DDL for all objects owned by SCHEMA_NAME
[Updated on: Wed, 21 January 2009 11:28] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
