OraFAQ Forum: SQL & PL/SQL » How to get complete schema

Home » SQL & PL/SQL » SQL & PL/SQL » How to get complete schema

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to get complete schema [message #22910]

Wed, 06 November 2002 01:18

Ramki
Messages: 26
Registered: September 2002

Junior Member

Is there is any way to get complet schema from DB.
i want get the complete schema of my project.
is there is any standart SQl for this ?
Regards
-Ramki

Report message to a moderator

Re: How to get complete schema [message #22913 is a reply to message #22910]

Wed, 06 November 2002 03:03

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You mean just the DDL scripts?
or also the data?????
Oracle does not have native tools to generate all DDL's
in a single snapshot.
you need to query views for that.
for stored procedure,functions etc --> user_source
triggers --> user_triggers
views --> user_views
etc.....
there are numerous third party tools available do the job, just like that.
like SQL NAVIGATOR,dbArtisan etc.
all you need to do is, select the schema, and generate DDL.
still oracle tools like DBAstudio does generate ddl script for all the objects. But you have to do it ONE by ONE.

Report message to a moderator

Re: How to get complete schema [message #22923 is a reply to message #22913]

Wed, 06 November 2002 10:02

andrew again
Messages: 2577
Registered: March 2000

Senior Member

The easiest way is to use export/import. I think you'll need to extract any public synonyms you want separately.

exp scott/tiger owner=scott file=scott.dmp
imp scott/tiger file=scott.dmp show=y log=scott_ddl.txt

--in Unix:
strings scott.dmp > scott_ddl.txt

Report message to a moderator

Re: How to get complete schema [message #22926 is a reply to message #22913]

Wed, 06 November 2002 10:30

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

Hi,
in case if u u r Db is 9i then u can make use of a package called as DBMS_Metadata which will have some method like get_sql() or get_ddl() (sorry dont remember exactly) so that u will get the complete DDl..

sai

Report message to a moderator

Previous Topic:	Lock on a row
Next Topic:	Can This Be Done

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 10:53:21 CDT 2024