Database Schema [message #382269] |
Wed, 21 January 2009 11:07 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136107.jpg) |
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
|
|
|
|