赞
踩
export ORACLE_SID=mydb
sqlplus /nolog
connect / as sysdba
create tablespace mydbtest datafile ‘/home/oracle/mydb.dbf’ size 1000m;
create user mydbuser identified by mypassword default tablespace mydbtest;
grant create session,create table,unlimited tablespace to mydbuser;
grant dba to mydbuser;
SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_size
FROM dba_tablespaces t, dba_data_files d
WHERE t.tablespace_name = d.tablespace_name
GROUP BY t.tablespace_name;
SELECT * FROM Dba_Data_Files ddf WHERE ddf.tablespace_name = 'DUAL_REFERRAL';
imp username/password@localhost/orcl file='E:\*.dmp' full=y;
exp system/666666@ORCL file=f:\demo\demo1.dmp full=y
exp system/666666@ORCL file=f:\demo\demo2.dmp owner=ORACLEDEMO(导出用户(例如我创建的ORACLEDEMO用户)下所有数据)
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。