OracleÊý¾Ý¿â±í¿Õ¼ä²Ù×÷

// ½¨Á¢±í¿Õ¼ä£¨Ö¸¶¨Îļþ·¾¶£©¡£
create TABLESPACE EAS_D_sptcc0_STANDARD DATAFILE 'F:\oracledb\EAS_D_sptcc0_STANDARD.dbf' size 10000M EXTENT MANAGEMENT local;
// ɾ³ý±í¿Õ¼ä£¨Ö¸¶¨Îļþ·¾¶£©¡£
DROP TABLESPACE temp_data INCLUDING CONTENTS AND DATAFILES;
// ½¨Á¢ÁÙʱ±í¿Õ¼ä¡£
CREATE TEMPORARY TABLESPACE EAS_D_sptcc0_STANDARD_temp TEMPFILE 'F:\oracledb\EAS_D_sptcc0_STANDARD_temp.dbf' SIZE 5000M;
// ½¨Á¢Óû§£¬ÃÜÂëÒÔ¼°Ä¬Èϵıí¿Õ¼äºÍÁÙʱ±í¿Õ¼ä¡£
create user sptcc0 identified by sptcc0 default tablespace EAS_D_sptcc0_STANDARD Temporary TABLESPACE EAS_D_sptcc0_STANDARD_temp;
// Óû§ÊÚȨ
grant connect,resource,dba to sptcc0;
// Ïòµ±Ç°±í¿Õ¼äµ¼ÈëÊý¾ÝÎļþ¡£
imp sptcc0/sptcc0@eas fromuser=sptcc touser=sptcc0 file='E:\2009-01-12_SPTCC.dmp' statistics=none
// ½¨Á¢Óû§£¬É趨ÃÜÂë¡£
create user sptcc0 identified by sptcc0;
// ÊÚȨÓû§Ó¦Óá£
grant create session to sptcc0;
grant create table to sptcc0;
grant create tablespace to sptcc0;
grant create view to sptcc0;
1.cmd
2.sqlplus
3.sptcc@eas_192.168.0.201 as sysdba
(sptcc@eas as sysdba)
password:kingdee
Ô¶³ÌÁ¬½Ó£ºadministrator
sptcc
¶ÔÖ¸¶¨µÄÓû§½øÐнâËø£º
alter user sptcc account unlock;
Task1 »Ö¸´×îвâÊÔ¿â
step1
怫sqlplus (as sysdba)
½¨Á¢±í¿Õ¼ä
create tablespace EAS_D_sptcc0_standard;
step2
ɾ³ýÒÑÓвâÊÔÓû§ drop user sptcc0 cascade;
step3
н¨²âÊÔÓû§ create user sptcc0 identified by sptcc default tablespace EAS_D_sptcc_STANDARD Temporary TABLESPACE EAS_D_sptcc_TEMP2 ;
step4
Óû§ÊÚȨ
grant connect,resource,dba to sptcc0;
Óû§ÊÚȨ²Ù×÷
step5
»Ö¸´ÕÊÌ×
imp sptcc0/sptcc@eas_192.168.0.201 fromuser=sptcc touser=sptcc0 file=D:\2009-01-12_SPTCC.dmp statistics=none
²âÊÔÓû§ÃÜÂë Ô´Êý¾ÝÓû§ µ±Ç°Êý¾ÝÓû§ Îļþ·¾¶