Empty table settings are also required
Owner can export empty table
Exp Ss_sc_manager/[email protected] Owner=ss_sc_manager file=d:\2017048 backup. DMP
Imp ss_sc_manager/[email protected] file=d:\2017048 backup. DMP
、、、、、、、、、、、、、、、、、、、、、
CREATE table space, etc.
Create tablespace ss_sc_db
datafile ' D:\SS_SC_DB. DBF ' size 10240M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
--Index tablespace
CREATE tablespace ss_sc_db_index
datafile ' D:\SS_SC_DB_Index.dbf ' size 512M
EXTENT MANAGEMENT LO CAL SEGMENT SPACE MANAGEMENT AUTO;
Create temporary tablespace ss_sc_db_temp
tempfile ' d:\SS_SC_DB_temp.dbf '
size 50m
Autoextend on
next 50m maxsize 20480m
Extent management local;
--2. Build Users
Create user Ss_sc_db_manager identified by Khdzkehai
Default Tablespace ss_sc_db
Temporary tablespace ss_sc_db_temp;
--3. Empowering
Grant Connect,resource to Ss_sc_db_manager;
Grant create any sequence to Ss_sc_db_manager;
Grant create any table to Ss_sc_db_manager;
Grant Delete any table to Ss_sc_db_manager;
Grant insert any table to Ss_sc_db_manager;
Grant Select any table to Ss_sc_db_manager;
Grant unlimited tablespace to Ss_sc_db_manager;
Grant execute any procedure to Ss_sc_db_manager;
Grant update any table to Ss_sc_db_manager;
Grant create any view to Ss_sc_db_manager;
Oracle Import Export Create user, etc.