添加用户 导数据

CREATE TABLESPACE "CRM_DB" 
    LOGGING 
    DATAFILE 'D:\oracle\product\10.2.0\oradata\crm\crm_db.ora' SIZE 
    1024M;


CREATE USER "CRM"  PROFILE "DEFAULT" IDENTIFIED BY "P" DEFAULT 
    TABLESPACE "CRM_DB" TEMPORARY 
    TABLESPACE "TEMP" ACCOUNT UNLOCK;

GRANT ALTER ANY SEQUENCE TO "CRM"  WITH ADMIN OPTION;
GRANT ALTER ANY TABLE TO "CRM"  WITH ADMIN OPTION;
GRANT ALTER DATABASE TO "CRM"  WITH ADMIN OPTION;
GRANT ALTER TABLESPACE TO "CRM"  WITH ADMIN OPTION;
GRANT ALTER USER TO "CRM"  WITH ADMIN OPTION;
GRANT CREATE ANY SEQUENCE TO "CRM"  WITH ADMIN OPTION;
GRANT CREATE ANY TABLE TO "CRM"  WITH ADMIN OPTION;
GRANT CREATE TABLE TO "CRM"  WITH ADMIN OPTION;
GRANT CREATE TABLESPACE TO "CRM"  WITH ADMIN OPTION;
GRANT CREATE USER TO "CRM"  WITH ADMIN OPTION;
GRANT DROP ANY TABLE TO "CRM"  WITH ADMIN OPTION;
GRANT DROP TABLESPACE TO "CRM"  WITH ADMIN OPTION;
GRANT DROP USER TO "CRM"  WITH ADMIN OPTION;
GRANT SELECT ANY SEQUENCE TO "CRM"  WITH ADMIN OPTION;
GRANT SELECT ANY TABLE TO "CRM"  WITH ADMIN OPTION;
GRANT UNLIMITED TABLESPACE TO "CRM"  WITH ADMIN OPTION;
GRANT "CONNECT" TO "CRM"  WITH ADMIN OPTION;
GRANT "DBA" TO "CRM"  WITH ADMIN OPTION;
GRANT "EXP_FULL_DATABASE" TO "CRM"  WITH ADMIN OPTION;
GRANT "IMP_FULL_DATABASE" TO "CRM"  WITH ADMIN OPTION;

grant select on sys.v_$session to "CRM";
grant select any dictionary to "CRM";
grant connect,resource to "CRM";


exp crm/p@183_XU file=d:\daochu.dmp owner=(crm)
imp crm/p@crm full=y file=d:\data\newsmgnt.dmp ignore=y