exp username/password@192.168.1.1:1521/orcl file=C:/database.dmp
select
tablespace_name,
file_id, file_name,
round(bytes/(1024*1024),0) total_space
from
dba_data_files
order by tablespace_name;
drop user user_name cascade;
drop tablespace tablespace_name including contents and datafiles cascade constraint;
create tablespace tablespace_name
logging
datafile 'C:\oracle\product\10.2.0\oradata\orcl\tablespace_name.dbf'
size 200m
autoextend on
next 200m maxsize 30480m
extent management local;
create user username_here identified by password_here default tablespace tablespace_here;
grant connect,resource,dba to username_here;
//imp 用户名密码ip端口服务名 要导入的dmp文件地址 fromuser是源dmp文件里的用户 touser是要更新的用户
imp username/password@orcl file=C:/database.dmp fromuser=fromusername touser=tousername
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。