question

BI DWH BALA avatar image
BI DWH BALA asked

Question on External tables?

Hi,

Is it possible to use same external table for multiple files with same structure?

Or is it a good practice to have one external table for each file?

Regards, BI DWH BALA

oracle
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
BI DWH BALA avatar image
BI DWH BALA answered

It seems that, we can specify list of file names in external table definition if the files are having same structure.

Any other suggestions are welcome.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.