Import from oracle database

[MarcoBoschi]

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

[Armando]

Marco:

Pls follow this thread

viewtopic.php?f=3&t=11902&p=58854&hilit=structure+table#p58854

Regards

[nageswaragunupudi]

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

[MarcoBoschi]

nageswaragunupudi and Armando,
Thanks a lot

Next week I'll try
marco