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

  • 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...
  • 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...
  • 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...
  • Data pump Export (expdp) patt #1
    Data Pump Export is a utility for unloading data and metadata into a set of operating system files called a dump file set. The dump file set...
  • Estimate Tablespace growth
    Some time it is very helpful to plan disk space/ tablespace management if you estimate the growth of your tablespace. Here is a select q...
  • 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...
  • Reverse Key Index
    I think we are familiar with Oracle Index, specially Bitmap Index. Indexes are used to help oracle retrieve data faster. But there is a dra...
  • TDE Part-2: Implement TDE Tablespace Encryption
    In this part, we will implement TDE Tablespace Encryption. As TDE Tablespace Encryption have several major benefits over TDE Column Encrypt...
  • 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...

Total Pageviews

Powered by Blogger.