ORACLE: DBA's day out

A blog about Oracle administration and configuration.

Tuesday, May 5, 2009

ORA-10631

Message: ORA-10631: SHRINK clause should not be specified for this object

Cause: shrink clause use inappropriately.

Solution: Write the syntax correctly. If a table has function based index or Text index, it can not be shrinked
Topic : ERROR: ORA-

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

post Topics

  • Oracle Basics (27)
  • Oracle Administration and Maintenance (18)
  • SQL PL/SQL Tips (18)
  • Oracle Tuning (16)
  • Export-Import (15)
  • ERROR: ORA- (14)
  • Oracle Tips And Tricks (11)
  • Installation and Configuration (5)
  • Day to Day Learning (4)
  • Flashback (3)
  • Administration and Maintenance (1)
  • Audit (1)
  • Recovery Manager (RMAN) (1)

Blog Archive

  • ►  2014 (2)
    • ►  April (2)
  • ►  2013 (10)
    • ►  July (2)
    • ►  June (2)
    • ►  May (3)
    • ►  March (3)
  • ►  2012 (2)
    • ►  April (1)
    • ►  January (1)
  • ►  2011 (10)
    • ►  December (2)
    • ►  October (2)
    • ►  July (3)
    • ►  May (1)
    • ►  March (1)
    • ►  January (1)
  • ►  2010 (1)
    • ►  October (1)
  • ▼  2009 (18)
    • ►  September (1)
    • ►  August (1)
    • ▼  May (2)
      • Who use Temporary Tablespace ?
      • ORA-10631
    • ►  April (4)
    • ►  March (1)
    • ►  February (5)
    • ►  January (4)
  • ►  2008 (70)
    • ►  December (6)
    • ►  November (3)
    • ►  October (13)
    • ►  September (10)
    • ►  August (2)
    • ►  July (6)
    • ►  June (3)
    • ►  May (14)
    • ►  April (13)
  • ►  2007 (11)
    • ►  June (1)
    • ►  May (1)
    • ►  April (9)

Popular Posts

  • DRIVING_SITE SQL Hint
    We all are know about Oracle Data Base Link and I called it dblink in short throughout this article. Usisg dblink you can easily access remo...
  • Using QUERY parameter in expdp/impdp
    In data pump export import we can use SQl query to filter exported/imported data. The parameter we use for this is 'QUERY'. But para...
  • Find Bind variable value
    The usages of bind variable increase SQL query performance. Suppose you have a SQL query that execute several times and only change are in l...
  • Manage SYS.AUD$ table
    From 11g, Oracle by default enable auditing with 'DB' option.  That means audit information will store in database table. With thi...
  • Changing Archive Log Destination
    In this article you will learn how to change the destination for archived redo log files. Sometime the location where archive redo log is fu...
  • Resize the Online Redo Log files
    When you are working on large data movement in Oracle, you must concern about some performance overhead and online redo log switch is one of...
  • TEXT Index Size
    Oracle Text Index, an interMedia Index, is powerful for searching user specified text within a column or columns. It is widely used in web a...
  • PL/SQL - Operator Precedence
    Hi all, It has been almost an year since I posted a topic in this blog. After a 1 year study break, I back to my usual job and hopfully I am...
  • SET DEFINE
    'SET DEFINE' is useful when you are working with sql*plus. There are three combinations of 'SET DEFINE' and those are: set d...
  • Alert: ASH performed an emergency flush
    Alert Active Session History (ASH) performed an emergency flush. This may mean that ASH is undersized. If emergency flushes are a rec...

Total Pageviews

Powered by Blogger.