oracle常用命令大全和环境变量路径(6)

select * from database_properties where property_name like 'NLS_CHA%'; NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

266 导出数据到一个文件中

exp userid=system/oracle file=full.dmp full=y

exp userid=system/oracle file=full1.dmp,full2.dmp,full3.dmp filesize=2g full=y direct=y log=full.log feedback=10000

267 导出指定用户的表

exp userid=system/oracle file=gary.dmp owner=gary,wei direct=y log=gary exp userid=system/oracle file=gary.dmp owner=gary direct=y log=gary.log

268 导出指定表

exp userid=system/oracle file=gary_a.dmp tables=gary.a direct=y log=gary

269 导出指定表

exp userid=system/oracle file=gary_a1.dmp tables=gary.a query='where owner=''GARY''' log=gary.LOG

270 查看导出的帮助信息 exp -help

271 删除gary的用户 drop user gary cascade;

272 重建用户GARY

CREATE USER \PROFILE \IDENTIFIED BY \ACCOUNT UNLOCK

273 授权用户GARY

GRANT UNLIMITED TABLESPACE,CONNECT,RESOURCE TO \

274 导入用户GARY的数据

imp userid=system/oracle fromuser=gary touser=gary show=y

imp userid=system/oracle fromuser=gary touser=gary file=full.dmp log=imp.log imp userid=system/oracle fromuser=gary touser=wei file=gary.dmp log=imp.log

275 查询状态

select object_name,object_type,owner from dba_objects where status='INVALID';

EXEC UTL_RECOMP.RECOMP_PARALLEL

276 建立对象,允许可以用这个目录来导入导出 create directory mydir as 'e:expdata';

277 授权用户的权限

grant read,write on directory mydir to gary;

278 导出数据

expdp userid=gary/gary dumpfile=gary directory=mydir PARALLEL=2 schemas=gary job_name=gary_job

expdp userid=gary/gary attach=gary_job

268 查询任务

SELECT * FROM V$DATAPUMP_JOB;

269 导入数据

impdp userid=system/oracle dumpfile=gary directory=mydir job_name=gary_job

oracle环境变量PATH 添加 c:\\oracle\\product\\10.2.0\\db_1\\bin;