Put your tips and tricks online - Share your knowledge! Login | Register
 
 
  Search     Advanced search
 

Home | Ask Question | Add tip | Questions | My tips | Recent tips & tricks | Suggest a category | FAQ | Forums

 
 
 
 Category : Home > Databases > Oracle > Oracle 10g     

WARNING: TEMP tablespace is not large enough for the upgrade


Apparently Oracle wants the default temporary tablespace to be locally managed when upgrading
from 10.1 to 10.2. When running utlu102i.sql script it throughs this warning if your temp
tablespace is dictionary managed:

--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 347 MB
WARNING: --> TEMP tablespace is not large enough for the upgrade.
.... currently allocated size: 0 MB
.... minimum required size: 68 MB
.... increase current size by:  MB
.... tablespace is NOT AUTOEXTEND ENABLED.

I am not sure what happens if you ignore this warning because I didn't, what I did was I
created a locally managed temporary tablespace and made it the temporary tablespace of SYS and
SYSTEM:

SQL> alter user sys temporary tablespace temp_local;
SQL> alter user system temporary tablespace temp_local;

After doing that the warning was gone.


  Options
 
   del.icio.us  |  newsvine  |  digg  |  furl  |  google  |  yahoo  |  Ma.gnolia  |  vigillar  |  reddit  |  technorati  |  icerocket  |  pubsub

       Rate this tip:    

Start discussion or add comment to this tip

  Details
Tip reference : #156
views : 2697
Added on : 01/23/07
Submited by : h8dk97
 
Send a message Send a message Printer friendly output Printer friendly output
Display this member's tips Display this member's tips (202)
 
 
<< Previous Next >>
 Most viewed tips 
  Databases > Oracle > Security : How to unlock Oracle user account  
  Databases > Oracle > Performance Tuning : How to enable trace in Oracle  
  Operating Systems > Unix : How to kill Unix user session  
  Databases > Oracle : Kill user session  
   
  All categories
Databases | Programming | Hardware | Operating Systems | Networking | Internet | ERP / CRM | Games & Multimedia | Graphics & Design | Miscellaneous | Mobile Phones / Tablets | Office Software
 
 

Home |  FAQ |  Terms of Use |  Privacy Policy

© 2005 tiplib.com