oracle imp

CREATE TABLESPACE "BIT_DEV"

LOGGING

DATAFILE 'D:\oracle\OraData\bit_dev01.ora' SIZE 2000M, 'D:\oracle\OraData\bit_dev02.ora' SIZE 2000M, 'D:\oracle\OraData\bit_dev03.ora' SIZE 2000M EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

CREATE

TEMPORARY TABLESPACE "BIT_DEV_TEMP" TEMPFILE

'D:\oracle\OraData\BIT_DEV_TEMP.ora' SIZE 200M EXTENT MANAGEMENT

LOCAL UNIFORM SIZE 1M;

create user bit_dev

identified by "bitok"

default tablespace bit_dev

temporary tablespace bit_dev_TEMP;


-- Grant/Revoke role privileges

grant connect to bit_dev;

grant exp_full_database to bit_dev;

grant imp_full_database to bit_dev;

grant resource to bit_dev;

-- Grant/Revoke system privileges

grant create procedure to bit_dev;

grant create trigger to bit_dev;

grant execute any procedure to bit_dev;

grant grant any privilege to bit_dev;

grant restricted session to bit_dev;

grant select any table to bit_dev;

grant unlimited tablespace to bit_dev;

grant create any view to bit_dev;
注意：如果表空间名称的大小写