Use Table Hyperlinks to Create an External Table
You can create an external table over an Autonomous Database Table Hyperlink.
You can use a single Autonomous Database Table Hyperlink or a comma-delimited list of Autonomous Database Table Hyperlinks to create an external table. See Query Data that Uses Table Hyperlink Source for more information.