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

  • ORACLE TEXT: Queries on Catalog Information
    T his example creates a catalog index for an auction site that sells electronic equipment such as cameras and CD players. New inventory is a...
  • 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...
  • 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...
  • 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...
  • Oracle Session Resource Profiler
    Introduction In short, OraSRP is a profiler. It parses extended SQL trace files and creates report which allows you to learn where your sess...
  • Recover Database from ORA-00333: redo log read error
    In development environment, it is very common scenario that we have multiple databases in a single machine by using VMware (i.e, each VMwar...
  • Find Top N resource absorbing SQL Queries
    At times database performance problems arise that require your diagnosis and correction. Sometimes problems are brought to your attention by...
  • Moving Oracle Text Index
    Moving an index from one tablespace to another tablespace is very easy task. It can be accomplished by using rebuild option: ALTER INDEX ind...
  • Transportable Tablespace (TTS)
    'Transportable Tablespace' (TTS) first introduce in Oracle 8i and it become matured as time goes by.  You can use this  feature t...
  • 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...

Total Pageviews

Powered by Blogger.