unrecoverable

ﾃﾞｰﾀ�L鐃��c�\�A�A�m�X�A�z�[��P��

�V鑛�t�B�B�E�k�B�V�E�\�E��B�V�E�P�B�B�E�F�E薀�b�E�
�j睛�j�B�BEXPLAN PLAN �E�E�E�J�E�m�A�q�A茲襯�u�E�b�E�T�E�P�E��E�P�A�z�N�B�Z��
�G�g�J��B�BOS�B�BWindows NT 4.0
�B�B�B�B�B�B�B�BOracle Oracle8 server
�Z��R��B�BORACLE "" �E�J�E�q�E絅�u�E襪�q�I��R��A�I�A譴�j�A�A�A�J�A�P

/*
|| UNRECOVERABLE
|| �A�E�A�zｺﾏﾝﾄﾞ�A��g蠅�P�A襪�l�E�l�E薀�J�E�b�E�L�E腑�}�E�z�B�V�E�u�B�V�E�H�E�A�E��E癲�V�E�m�A�k�V�c�P��A�I�A�
|| �E蹈�e�E襯�~�E�e�E�b�E�T�E�[�E瓮�l�E�l�g�E�E�B�E蕁�V�A眸�b�^�N�A�L�A�n�A�A
*/

/*
|| *** �e躇�� ***
|| �E�j�B�V�E��E襪�q�g�Z�X��A�I�A譴襪�z�A�k�B�u�E�k�B�V�E�\�A��C譴�j�A�A�A訃豺腓�}�n篏�I�A譴�n�A�A
|| �q��l��G�g�J��A�k�V�c�P��A�P�A襪�E�A�l�A�}�\箴�D�A�L�A�n�A�A
*/

�B��Sample�B��

-- �R鄒��E�j�B�V�E��E襪�z�R鐔�
TRUNCATE TABLE TEST_B ;
-- �E�j�B�V�E��E襪�z�R鄒��
CREATE TABLE TEST_B (
NUM
,CHAR2
)
PCTFREE 15
TABLESPACE TYT
STORAGE (
INITIAL 1000
NEXT 100
PCTINCREASE 0
)
UNRECOVERABLE
AS SELECT * FROM TEST_A
;
-- �E�j�B�V�E��E詭�Z�n��P�P
RENAME TEST_A TO TEST_A_OLD ;
RENAME TEST_B TO TEST_A ;