新建逻辑目录
Oracle不会自动创建实际的物理目录“D:\temp”(务必手动创建此目录),仅仅是进行定义逻辑路径dmp_dir;
sql>conn username/password@orcl as sysdba;
sql>create directory dmp_dir as 'd:\temp';
sql>select * from dba_directories;
oracle 定义路径前必须创建物理地址,不然会出现如下错误。
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
导出时出现如下错误,表示没有给用户授权(grant exp_full_database to username;)
ORA-31631: privileges are required
ORA-39161: Full database jobs require privileges
导入时出现如下错误,表示没有给用户授权(grant imp_full_database to username;)
ORA-31631: privileges are required
ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings.
转载至链接:/fengzhi714/blog/1844559