createuser.sql

来自「oracle 全文检索的示例代码. 实现基于分区表的全文检索实现」· SQL 代码 · 共 54 行

/***************************************************************************  
*	数据库创建脚本                                                            
*                                                                             
*	完成数据库的创建、用户(miss)的创建，                          
*	用户数据的导入                                                            
*                                                                             
*	auth:jidongzheng                                                          
*	2005-1-31                                                                 
*	                                                                          
*
****************************************************************************/ 

prompt
prompt
prompt Creating user miss
prompt
create tablespace miss  noLOGGING 
    datafile 
    '$HOME/oradata/$ORACLE_SID/miss01.dbf' size 30M AUTOEXTEND ON NEXT  2m MAXSIZE  20480M,
    '$HOME/oradata/$ORACLE_SID/miss02.dbf' size 30M AUTOEXTEND ON NEXT  2m MAXSIZE  20480M     
    EXTENT MANAGEMENT LOCAL segment space management auto;
create tablespace idx_miss noLOGGING 
    datafile 
    '$HOME/oradata/$ORACLE_SID/idx_miss01.dbf' size 30M AUTOEXTEND ON NEXT  2m MAXSIZE  20480M,
    '$HOME/oradata/$ORACLE_SID/idx_miss02.dbf' size 30M AUTOEXTEND ON NEXT  2m MAXSIZE  20480M
    EXTENT MANAGEMENT LOCAL segment space management auto;
create tablespace I_misstbs noLOGGING     
    datafile 
    '$HOME/oradata/$ORACLE_SID/i_miss01.dbf' size 30M AUTOEXTEND ON NEXT  2m MAXSIZE  20480M,
    '$HOME/oradata/$ORACLE_SID/i_miss02.dbf' size 30M AUTOEXTEND ON NEXT  2m MAXSIZE  20480M    
    EXTENT MANAGEMENT LOCAL segment space management auto;
create tablespace misslob noLOGGING 
    datafile 
    '$HOME/oradata/$ORACLE_SID/misslob01.dbf' size 30M AUTOEXTEND ON NEXT  2m MAXSIZE  20480M,
    '$HOME/oradata/$ORACLE_SID/misslob02.dbf' size 30M AUTOEXTEND ON NEXT  2m MAXSIZE  20480M        
    EXTENT MANAGEMENT LOCAL segment space management auto;

create user miss identified by miss default tablespace miss account unlock;
grant connect to miss;
grant resource to miss;
grant IMP_FULL_DATABASE to miss;
grant ctxapp to miss;
grant execute on ctx_ddl to miss;

alter user ctxsys account unlock;
alter user ctxsys identified by ctxsys ;
disc;
conn ctxsys/ctxsys
exec ctx_adm.set_parameter('max_index_memory', '2040M');
exec ctx_adm.set_parameter('default_index_memory', '600M');


exit;