如题:
代码如下:expdp cms0412_cn/cms0412_cn directory=dp_test dumpfile=cms0412_cn.dmp full=y logfile=cms0412_cn.log;Export: Release 10.2.0.1.0 - Production on D??ú?t, 04 5??, 2010 11:11:33Copyright (c) 2003, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39006: internal error
ORA-39213: Metadata processing is not available 望高手帮忙解决!
代码如下:expdp cms0412_cn/cms0412_cn directory=dp_test dumpfile=cms0412_cn.dmp full=y logfile=cms0412_cn.log;Export: Release 10.2.0.1.0 - Production on D??ú?t, 04 5??, 2010 11:11:33Copyright (c) 2003, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39006: internal error
ORA-39213: Metadata processing is not available 望高手帮忙解决!
Cause: The Data Pump could not use the Metadata API. Typically, this is caused by the XSL stylesheets not being set up properly.
Action: Connect AS SYSDBA and execute dbms_metadata_util.load_stylesheets to reload the stylesheets.
但是新的问题又出来了!见以下代码:oracle@suse11:~> expdp cms0412_cn/cms0412_cn DIRECTORY=dp_test DUMPFILE=cms0412_cn.dmp full=y logfile=cms0412_cn.log;Export: Release 10.2.0.1.0 - Production on 星期二, 04 5月, 2010 12:15:00Copyright (c) 2003, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation
权限是有的,我授予的是dba的权限!
按提示是说:文件操作无效!
权限是有的!不知道问题出在哪?
grant read,write on DP_TEST to cms0412_cn
我也遇到这个问题了,很遗憾你没有告诉大家是怎么解决的。最后我明白了,因为我没有在操作系统上创建那个备份文件存放目录。在oracle中执行 create directory dir_name as '/opt/temp/gct' 这个命令时并不会检查 /opt/temp/gct这个目录是否存在。这个目录需要在操作系统中创建。