表空间

1、新建表空间

create tablespace IBA_HOME  datafile '/home/oracle/oradatafile/testbd/testrpt.dbf' size 1024M  autoextend on next 50M maxsize 20480M;
autoextend on next：每次50M
maxsize：自动扩展到2G
  临时表空间：
create temporary tablespace RPT_TEMP  tempfile '/home/oracle/oradatafile/testbd/temp.dbf' size 1024M;
3、    增加表空间(2种方法)
增加数据文件：
ALTER TABLESPACE IBA_HOME ADD DATAFILE '/home/oracle/oradatafile/testbd/testrpt01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M MAXSIZE 2000M;
扩展当前数据文件：

ALTER DATABASE DATAFILE '/home/oracle/oradatafile/testbd/testrpt.dbf' RESIZE 50000M;

1、    创建备份目录
mkdir -p /opt/oracle/backup
2、    设置字符集
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
3、创建directory目录
sqlplus sys/Password as sysdba
create or replace directory DUMP_DIR as '/opt/oracle/backup';
grant read,write on directory DUMP_DIR to d0;
exit;
4、    导出数据库.
expdp test22db_d0/ test22db_d0@mdspdb dumpfile=testdb.dmp directory=DUMP_DIR schemas= test22db_d0 content=ALL;
5、    在目标数据库服务器上创建备份目录
mkdir -p /opt/oracle/backupD01
6、    将导出文件上传至backupD01目录下
7、    创建directory目录
sqlplus sys/Password as sysdba
create or replace directory DUMP_DIRD01 as '/opt/oracle/backupD01';
grant read,write on directory DUMP_DIRD01 to testdb;
exit;
8、    进入backupD01目录导入数据
impdp test22db_d0/test22db_d0@testdb directory=DUMP_DIRD01 dumpfile=test22db_d0.dmp TABLE_EXISTS_ACTION=REPLACE remap_tablespace=TBS_test_STAT:IBA_HOME;
9、    导入完成后验证
select count(*) from user_objects;
对象数和源数据库一致