Get Data - Oracle Tables import

[revansh]

Hi,

I am trying to import couple of tables from oracle database. There are around 10k tables in the SCHEMA. when i expand the schema it is showing the list of first 2-3 hundred tables. When i search with table name , required table is not showing up.

But when i use SELECT * from tablename , i am able to import data.

Please help.

Thanks

[v-shex-msft]

Hi @revansh,

It sounds odd, I think it may due to there are too many tables need to be caching.
For your scenario, I'd like to suggest you direct use advanced statement with T-sql query to choose specific tables.

Regards,

Xiaoxin Sheng