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. ...

have you looked into using Toad? http://www.toadsoft.com/toad_oracle.htm

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 ...

WANT_AD is the table and CLASSMATE is the schema. How do I display the DLL command that created the table?