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...
  • 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...
  • 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...
  • 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...
  • 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...
  • ORA-14519 Conflicting tablespace blocksizes while importing partition tables
    ORA-14519: Conflicting tablespace blocksizes for table : Tablespace T2 block size 16384 [partition specification] conflicts with previous...
  • 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...
  • installation of Oracle Text on 10g
    This article lists the steps for manual installation of Oracle Text 10gR1 and 10gR2, verification and uninstalling Oracle Text installation....

Total Pageviews

Powered by Blogger.