Help - extract schema DDL (select access to that schema only)
Group,
I want to generate the DDL code for a 1288 table db, then create dump code for an oracle conversion project. Once I get a clean listing of the table and column names, I know I can program to generate all the code in PL/SQL or SQLPLUS.
I have select access to 1 of a databases 50+ schemas, nothing else. I've been trying the recommended query techniques I've seen (including here), and the result sets are empty, with the exception of "select * from all_objects where owner = 'schema_owner_name';", which returns all the table names. I don't see any indexes.
I'd like to see a select for the schema I have access to with the tablename and column names so I can easily parse it. I know it must visible as it shows up in SQL Developer.
As to the indexes, is it possible that they could be attached to a synonym schema? The database is supposed to have a synonym for this schema, but I have no access to it.
Any help would be great
Thanks,
Vince