Skip to main content
eZabel
Login
0 online
Forum / Just starting Oracle 10g View full thread →
theremin Nov 2, 2006

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

iwz Nov 2, 2006

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

theremin Nov 2, 2006

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

theremin thereminOG 2002

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

iwz iwz

no idea

iwz iwz

all i know is in SQL Navigator, you can right click on a table and say Extract DDL

theremin thereminOG 2002

Where's SQL Navigator? Is that even in 10g?

iwz iwz

it's a 3rd party app that we purchased years and years ago

theremin thereminOG 2002

hrm. I was looking for a free solution. A free, simple solution.

iwz iwz

that's why i recommended Toad.

← View full thread

Welcome Back to eZabel

It's been a while. Here's what's new.

eZabel Lore

A complete history of our community — stats, Hall of Fame, legendary threads, and more.

View the Lore →

Everything Preserved

All 225,969 pieces of content from 2000–2014 are here — forums, messages, journals, photos, polls, and events.

💎

Gems

Spot something you love — a legendary comment, a classic thread, a great photo? Log in and click the diamond icon to mark it as a Gem. Add a note about why it's special. The best stuff surfaces on the Gems page.