Oracle数据库初始化脚本

create tablespace mhpt datafile 'E:\htzqjj\ts_data.ora' size 1000m;

select file_id from dba_data_files where tablespace_name='MHPT';

alter database datafile 9 autoextend on next 10M;  --9是之前查出的file_id;

grant create any index to NAME;

grant create database link to NAME;

grant create procedure to NAME;

grant create sequence to NAME;

grant create table to NAME;

grant create view to NAME;

grant debug connect session to NAME;

grant delete any table to NAME;

grant select any table to NAME;

grant unlimited tablespace to NAME;

grant update any table to NAME;

grant dba to NAME;

grant connect to NAME;

grant resource to NAME;

imp mhpt/mhpt2@127.0.0.1/orcl file=D:\mhpt_20170726.dmp log=D:\temp\log.txt full=y ignore=y