DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES;
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE '/dtls02/tls/o01tls3temp/temp_05.O01TLS3' SIZE 8000M AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL UNIFORM. SIZE 128K ;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP;
DROP TABLESPACE TEMP0 INCLUDING CONTENTS AND DATAFILES;
CREATE TEMPORARY TABLESPACE TEMP0 TEMPFILE
'/dtls02/tls/o01tls3temp/temp0_03.O01TLS3' SIZE 5000M AUTOEXTEND OFF,
'/dtls02/tls/o01tls3temp/temp0_04.O01TLS3' SIZE 5000M AUTOEXTEND OFF,
'/dtls02/tls/o01tls3temp/temp0_05.O01TLS3' SIZE 5000M AUTOEXTEND OFF,
'/dtls02/tls/o01tls3temp/temp0_06.O01TLS3' SIZE 5000M AUTOEXTEND OFF,
'/dtls02/tls/o01tls3temp/temp0_01.O01TLS3' SIZE 1000M AUTOEXTEND OFF,
'/dtls02/tls/o01tls3temp/temp0_02.O01TLS3' SIZE 1000M AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL UNIFORM. SIZE 1M;
'/dtls02/tls/o01tls3temp/temp0_03.O01TLS3' SIZE 5000M AUTOEXTEND OFF,
'/dtls02/tls/o01tls3temp/temp0_04.O01TLS3' SIZE 5000M AUTOEXTEND OFF,
'/dtls02/tls/o01tls3temp/temp0_05.O01TLS3' SIZE 5000M AUTOEXTEND OFF,
'/dtls02/tls/o01tls3temp/temp0_06.O01TLS3' SIZE 5000M AUTOEXTEND OFF,
'/dtls02/tls/o01tls3temp/temp0_01.O01TLS3' SIZE 1000M AUTOEXTEND OFF,
'/dtls02/tls/o01tls3temp/temp0_02.O01TLS3' SIZE 1000M AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL UNIFORM. SIZE 1M;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP0;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22578826/viewspace-718898/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
