MAXIMO数据库导入脚本

1、

ALTER SYSTEM SET open_cursors = 1000 SCOPE=MEMORY;

ALTER SYSTEM SET pga_aggregate_target = 37748736 SCOPE=MEMORY;

ALTER SYSTEM SET cursor_sharing = "FORCE" SCOPE=MEMORY;

ALTER SYSTEM SET java_pool_size = 33554432 SCOPE=MEMORY;

ALTER SYSTEM SET large_pool_size = 8388608 SCOPE=MEMORY;

ALTER SYSTEM SET nls_length_semantics = "CHAR" SCOPE=MEMORY;

ALTER SYSTEM SET shared_pool_size = 157286400 SCOPE=MEMORY;

commit;

 

2、

CREATE TABLESPACE MAXIMO_DATA  DATAFILE 'D:/oracle/product/10.2.0/oradata/maximo/maximo_data'  SIZE  1000M AUTOEXTEND ON MAXSIZE 30000M;

CREATE TABLESPACE MAXIMO_INDEX  DATAFILE 'D:/oracle/product/10.2.0/oradata/maximo/maximo_index' SIZE  1000M AUTOEXTEND ON MAXSIZE 3000M;

CREATE TEMPORARY TABLESPACE MAXIMO_TEMP  TEMPFILE 'D:/oracle/product/10.2.0/oradata/maximo/maximo_temp' SIZE  1000M AUTOEXTEND ON MAXSIZE unlimited;

 

 

CREATE TABLESPACE MAXIMO_DATA  DATAFILE 'D:/oracle/product/10.2.0/oradata/maximo/maximo_data'  SIZE  1000M AUTOEXTEND ON MAXSIZE 30000M;

CREATE TABLESPACE MAXIMO_INDEX  DATAFILE 'D:/oracle/product/10.2.0/oradata/maximo/maximo_index' SIZE  500M AUTOEXTEND ON MAXSIZE 3000M;

CREATE TEMPORARY TABLESPACE MAXIMO_TEMP  TEMPFILE 'D:/oracle/product/10.2.0/oradata/maximo/maximo_temp' SIZE  500M AUTOEXTEND ON MAXSIZE unlimited;

 

3、

Create user maximo identified by maximo;

alter user maximo default tablespace maximo_data quota unlimited on maximo_data;

alter user maximo quota unlimited on maximo_index;

alter user maximo temporary tablespace MAXIMO_TEMP;

grant create job to maximo; 

grant create trigger to maximo; 

grant create session to maximo; 

grant create sequence to maximo; 

grant create synonym to maximo; 

grant create table to maximo; 

grant create view to maximo; 

grant create procedure to maximo; 

grant alter session to maximo; 

grant execute on ctxsys.ctx_ddl to maximo; 

grant dba to maximo;

 

 

imp maximo/maximo@maximo file=d:/DBBackup_Logic_NSRD.dmp log=d:/maximoimp.log fromuser=maximo   touser=maximo     grants=n ignore=y feedback=10000 buffer=1024000