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;