If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

How to list all table names and get the database ddl

After install oracle 10g personal edition on windows XP home edition, the enterprise manager database control didn't work. I log in as super user SYSTEM, but EM database control always show error "the account is locked" and I can only startup/shutdown database, no other functions available.

While I'm waiting for my new PC on windows XP professional edition, I try to get some ddl from the example schema. How can I list all the table names and ddl for entire database using sqlplus ????