DECLARE
V_FILENAME VARCHAR2(200);
BEGIN
select SUBSTR(FILE_NAME,
1,
LENGTH(FILE_NAME) - INSTR(REVERSE(FILE_NAME), '/') + 1)
INTO V_FILENAME
from dba_data_files
where tablespace_name = 'ZSDATA'
AND ROWNUM = 1;
EXECUTE IMMEDIATE 'CREATE SMALLFILE
TABLESPACE ZSMEMBER_DATA
LOGGING
DATAFILE ''' || V_FILENAME ||
'zsmember_data.dbf'' SIZE 5M REUSE
AUTOEXTEND
ON NEXT 5120K MAXSIZE 32767M EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO ';
EXECUTE IMMEDIATE 'CREATE SMALLFILE
TABLESPACE ZSMEMBER_IDX
LOGGING
DATAFILE ''' || V_FILENAME ||
'zsmember_idx.dbf'' SIZE 5M REUSE
AUTOEXTEND
posted on 2011-08-22 17:57
David1228 閱讀(406)
評(píng)論(0) 編輯 收藏 所屬分類:
數(shù)據(jù)庫(kù)