I tried to use datapump to import a whole database but I want to include sys and system. I specified exclude=schema:sys,system and got the following errors:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing options
ORA-39001: invalid argument value
ORA-39071: Value for EXCLUDE is badly formed.
ORA-00920: invalid relational operator
ORA-06512: at "SYS.KUPM$MCP", line 2687
Solution: "exclude=schema:\"='SYS'\"" "exclude=schema:\"='SYSTEM'\""
Reference Oracle note 734324.1 .
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment