shrink in manual space managment tablespace [message #524801] |
Mon, 26 September 2011 21:11 |
andy huang
Messages: 498 Registered: July 2011
|
Senior Member |
|
|
Dear all,
Does It can not shrink in manual space managment tablespace?
I was confused by the error ORA-10637: The segment does not exist
create tablespace test_manual
datafile 'd:\oracle\oradata\orcl\test_manual.dbf' size 100m
segment space management manual
create user test_man identified by hxl
default tablespace test_manual;
grant create session to test_man;
grant resource to test_man;
login as test_man
SQL> Create Table tb_test_shrink
2 (
3 Id Number,
4 Name Varchar2(64)
5 );
Table created.
SQL> Select aa.TABLE_NAME,aa.TABLESPACE_NAME
2 From user_tables aa
3 Where aa.TABLE_NAME = 'TB_TEST_SHRINK';
TABLE_NAME TABLESPACE_NAME
------------------------------ ------------------------------
TB_TEST_SHRINK TEST_MANUAL
SQL> Alter Table TB_TEST_SHRINK Shrink Space Cascade;
Alter Table TB_TEST_SHRINK Shrink Space Cascade
*
ERROR at line 1:
ORA-10637: The segment does not exist
|
|
|
|
Re: shrink in manual space managment tablespace [message #524804 is a reply to message #524801] |
Mon, 26 September 2011 23:07 |
|
Michel Cadot
Messages: 68716 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Quote:Does It can not shrink in manual space managment tablespace?
In addition, in your previous topic I gave you a link to the documentation about shrink and John already gave you the answer to THIS question,
You didn't read it.
You NEVER read the documentation wr pointed you.
Show a little respect towards us and READ what we give you and NO MORE post a question we already answered you.
Regards
Michel
[Updated on: Mon, 26 September 2011 23:08] Report message to a moderator
|
|
|
|