Home » SQL & PL/SQL » Client Tools » Database Schema (Oracle 10.2.0.1.0 - Linux)
Database Schema [message #382269] Wed, 21 January 2009 11:07 Go to next message
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 #382271 is a reply to message #382269] Wed, 21 January 2009 11:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dbms_metadata

Regards
Michel
Re: Database Schema [message #382272 is a reply to message #382269] Wed, 21 January 2009 11:28 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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

Re: Database Schema [message #382274 is a reply to message #382269] Wed, 21 January 2009 11:39 Go to previous message
danyromimd
Messages: 73
Registered: August 2008
Member
Thanks to both of you!
Previous Topic: How to connect oracle server
Next Topic: Is there any tool avilable to find out the name of the Stored Procedure/Function/Package?
Goto Forum:
  


Current Time: Thu Dec 08 02:21:35 CST 2016

Total time taken to generate the page: 0.10992 seconds