Mview Create DDL Statement From Impdp with Sqlfile Option
(Doc ID 1528826.1)
Last updated on MAY 19, 2022
Applies to:
Oracle Database Exadata Express Cloud Service - Version N/A and laterOracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
Goal
Using datapump to export some materialized views from one database, and creating a sqlfile to use to create them in a new database. The syntax appearing in the sqlfile does not look like the normal syntax used for creating a materialized view.
For example :
Unsure what the information is beginning with "USING" clause.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |