Can we view the Oracle Default Schema in the ADW?

Amrit · Nov 21, 2022 3:10PM

Can we view the Oracle Default Schema where the data is stored out of the box by running the process using the pipeline settings in the ADW by connecting it with the SQL developer?

Ravi Guddanti-Oracle · Nov 21, 2022 3:36PM

Amrit, OAX_USER schema has synonyms to the out of the box warehouse tables. You may connect to this schema using SQL Developer. Reference this blog.

Ravi

Amrit · Nov 21, 2022 4:12PM

Hi Ravi,

Please provide the blog link.

Thanks and Regards,

Amrit

Ravi Guddanti-Oracle · Nov 21, 2022 4:14PM

https://blogs.oracle.com/analytics/post/how-to-connect-oracle-fusion-analytics-warehouse-to-oracle-autonomous-data-warehouse-using-sql-developer

Blog

Amrit · Nov 21, 2022 4:21PM

Thank you. This helps.

Oracle Fusion AI Data Platform

Categories

Can we view the Oracle Default Schema in the ADW?

Answers