Oracle导入导出

  • A+
所属分类:Oracle
1.导出到默认路径/u01/admin/orcl/dpdump

expdp tj_mvdtcity/tj_mvdtcity dumpfile=tj_mvdtcity.dump logfile=tj_mvdtcity.log

tj_mvdtcity用户名和密码
2.导入
impdp tj_mvdtcity/tj_mvdtcity dumpfile=tj_mvdtcity.dump remap_schema=tj_mvdtcity:tj_mvdtcity remap_tablespace=tj_mvdtcity:tj_mvdtcity
3.查看实例
select instance_name from v$instance;
4.查询数据库名
show parameter db_name;
5.查询表空间及状态
select tablespace_name, block_size, status, contents, logging from dba_tablespaces;
6.查询表空间存放位置及大小
SELECT file_id, file_name, tablespace_name, status, bytes from dba_data_files;
select file_name, tablespace_name from dba_data_files;
7.查看用户的创建时间
select username,created from dba_users;
8.查看数据库字符集
select userenv('language') from dual
9.查询oracle用户连续输入多少次被锁定
select resource_name,limit from dba_profiles where resource_name='FAILED_LOGIN_ATTEMPTS';
10.解锁账户,username为用户名
alter user username account unlock;
11.重置oracle用户名密码
alter user ytrcTrace identified by ytrcTrace;
12.删除oracle用户
drop user zslt cascade;


avatar

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: