Hi,
I have to extract all data from an Oracle database.
The problem is that I don't know anything: table names, table structure, etc, etc
The question is:
How to obtain the list of tables present into the database?
Thanks in advance
Marco:
Pls follow this thread
viewtopic.php?f=3t=11902p=58854hilit=structure+table#p58854
Regards
&&&
ADOX works as recommended above,
Another way is to use the SQL statment
SELECT OWNER, TABLE_NAME FROM ALL_TABLES.
Depending on the rights of the querying user, he gets a list of all Schemas ( as OWNER ) and all Tables within each schema, to which he has access
nageswaragunupudi and Armando,
Thanks a lot
Next week I'll try
marco
