Aug 11, 2006 #1 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, 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
Aug 11, 2006 #2 Turkbear Technical User Mar 22, 2002 8,631 US 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: http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76955/ch01.htm#32405 Or in your Manuals... To Paraphrase:"The Help you get is proportional to the Help you give.." Upvote 0 Downvote
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: http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76955/ch01.htm#32405 Or in your Manuals... To Paraphrase:"The Help you get is proportional to the Help you give.."
Aug 15, 2006 Thread starter #3 beechill4 Technical User May 10, 2005 207 IE thanks turk, i'll give that a go Upvote 0 Downvote