Where can "Schema Manager" be found in 10g? Being the EM is browser based and not a console window. Is there a Schema Mgr in 10g?
What I want to do is find a table in a schema called blah. I have to display the DDL command that created the table using this schema gr method.
But, if there is not a schema manager in 10g (the book seems to have been written for a previous version of Oracle) then can this same task be done a different way, like within SQL Plus?
have you looked into using Toad?
http://www.toadsoft.com/toad_oracle.htm
Haven't.
I tried doing via command in SQL Plus window this way but doesn't work:
SQL> SELECT DBMS_METADATA.GET_DDL('TABLE', WANT_AD) FROM CLASSMATES;
SELECT DBMS_METADATA.GET_DDL('TABLE', WANT_AD) FROM CLASSMATES
*
ERROR at line 1:
ORA-00942: table or view does not exist
WANT_AD is the table and CLASSMATE is the schema. How do I display the DLL command that created the table?
no idea
all i know is in SQL Navigator, you can right click on a table and say Extract DDL
okay, I'm in Enterprise Manager browser window. Clicked "Tables" link under "Schema," when the search field came up on the next page, I typed in the Schema box, the appropiate schema name, Click on "Go", clicked the radio button for the table I want.
Now, how do display the DDL command that created the table?