Oracle简单操作

xiaoxiao2026-03-18 12

--创建用户 createuser username IDENTIFIED BY username; --用户授权 grant dba to username; ---删除用户 drop user user_name cascade； --创建逻辑目录 create or replace directory data_dump as 'e:\aa'; --查询逻辑目录 select * from dba_directories; --导出数据库 exp username/pwd@orcl owner=username file=d:/dpdump/test.dmp LOG=d:/dpdump/test.log expdp username/pwd@orcl schemas=username(多个可用逗号隔开) DIRECTORY=DATA_DUMP dumpfile=test.dmp logfile=test.log --导入数据库(ignore忽略错误full完全导入) imp username/pwd@orcl file=d:\dumpfile\test.dmp ignore=y full=y logfile=d:\dumpfile\test.log imp username/pwd@orcl file=d:\dumpfile\test.dmp fromuser =username touser =username1 logfile=d:\dumpfile\test.log impdp username/pwd@orcl directory=DATA_DUMP dumpfile=test.DMP logfile=test.log REMAP_SCHEMA=username:username1 --查看表空间及大小 select tablespace_name, file_id,file_name, ROUND(bytes/(1024*1024),0)||'M' total_space from dba_data_files order by tablespace_name

转载请注明原文地址: https://ju.6miu.com/read-1308102.html

最新回复(0)