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...
  • 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...
  • Managing Indexes Part #1
    Indexes are optional structures associated with tables and clusters that allow SQL statements to execute more quickly against a table. An Or...
  • Bind variables
    If you've been developing applications on Oracle for a while, you've no doubt come across the concept of « Bind Variables ...
  • 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...
  • 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...
  • 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...
  • 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...

Total Pageviews

Powered by Blogger.