导入dmp

1-----/*建立表空间tlds_space 。放在D:\data_bak\tlds\tlds_space.ora 下，大小为200兆*/
CREATE TABLESPACE tlds_space DATAFILE 'D:\data_bak\tlds\tlds_space.ora' SIZE 20G EXTENT 
    MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;
CREATE TABLESPACE tlds_space_HISTORY DATAFILE 'D:\data_bak\tlds\tlds_space_historydata.ora' SIZE 1000M EXTENT 
    MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;
CREATE TABLESPACE tlds_space_INDEX DATAFILE 'D:\data_bak\tlds\tlds_space_indexdata.ora' SIZE 1000M EXTENT 

    MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;

2----创建临时表空间
CREATE TEMPORARY TABLESPACE tlds_temp TEMPFILE 'D:\data_bak\tlds\tlds_temp.ora' SIZE 1000M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
3----创建用户和赋予权限
CREATE USER cell IDENTIFIED BY cell DEFAULT TABLESPACE tlds_space TEMPORARY TABLESPACE tlds_temp PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT CONNECT TO cell WITH ADMIN OPTION;
GRANT RESOURCE TO cell WITH ADMIN OPTION;
GRANT DBA TO cell WITH ADMIN OPTION;
GRANT UNLIMITED TABLESPACE TO cell;
ALTER USER cell DEFAULT ROLE ALL;
4-----导入DMP包 
imp cell/cell@tlds file=E:\share\dataold7\databak\tmp\rone4.dmp show=n buffer=2048000 
ignore=y grants=y full=y log=E:\share\dataold7\databak\tmp\rone4.log