jiahengzhang的专栏

oracle10导出数据时在exporting cluster definitions挂起设置LD_LIBRARY_PATH 和 LIBPATH环境变量为D:\oracle\product\10.1.0\db_3\LIB重启oracle服务,顺利导出

一共分为两个部分，一共为bat批处理

-- 命令行以dba身份登录sqlplus sys/orcl as sysdba-- 创建表空间create tablespace oawf1 datafile 'e:/oawf1.dbf' size 100M  autoextend on next 100M maxsize unlimited;-- 创建用户并添加密码create user oawf1 identified

About to export specified users ...  . exporting pre-schema procedural objects and actions  . exporting foreign function library names for user SYSTEM   . exporting PUBLIC type synonyms  

oracle 临时表空间的增删改查1、查看临时表空间 （dba_temp_files视图）（v_$tempfile视图）select tablespace_name,file_name,bytes/1024/1024 file_size,autoextensible from dba_temp_files;select status,enabled, name, bytes/102

一、创建 directory 目录 1. dba连接数据库C:\Users\Administrator>sqlplus system/password@orcl as sysdba;创建目录 指向路径SQL>create directory dir_dp as 'D:/Oracle/directory/dir_dp';赋予读写权限SQL>grant read,write on dir_d