Home » RDBMS Server » Server Administration » shrink in manual space managment tablespace (11.2.0.1.0 Windos XP)
shrink in manual space managment tablespace [message #524801] Mon, 26 September 2011 21:11 Go to next message
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 #524803 is a reply to message #524801] Mon, 26 September 2011 22:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/E14072_01/server.112/e10595/tables002.htm#insertedID8
Re: shrink in manual space managment tablespace [message #524804 is a reply to message #524801] Mon, 26 September 2011 23:07 Go to previous messageGo to next message
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

Re: shrink in manual space managment tablespace [message #524810 is a reply to message #524804] Tue, 27 September 2011 00:33 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,i will read the doc.
Previous Topic: important question [merged 3]
Next Topic: ASM rebalance operation never end
Goto Forum:
  


Current Time: Fri Nov 29 04:49:24 CST 2024