Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

extract ddl from 8i database

Status
Not open for further replies.

beechill4

Technical User
May 10, 2005
207
IE
Hi,

I have an 8i database running on hp-ux

can you advise me the best way to extract the ddl for
tablespaces
tables
indexes
constraints
grants
users
privileges.

i do not have access to any 3rd party tools or dba studio.

Thanks
 
Hi,
You can use the EXP command with the ROWS='N' to export the definitions needed to recreate the structure --

Not sure about the other parameter settings so you can read about those here:


Or in your Manuals...



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top