Database Administration (MOSC)

MOSC Banner

Error During Oracle 11g Upgrade

edited Apr 2, 2009 1:37AM in Database Administration (MOSC) 10 commentsAnswered ✓
 Hi,

The following is the error I got when run the catupgrd.sql after I issue 'startup upgrade'. Please help. Thank you in advance.

SQL> -- we also need to update the statistic
SQL> begin
  2    dbms_stats.delete_table_stats('SYS', 'OBJ$MIG');
  3    dbms_stats.delete_table_stats('SYS', 'USER$MIG');
  4    dbms_Stats.gather_table_stats('SYS', 'OBJ$MIG',  estimate_percent => 100,
  5                                   method_opt=>'FOR ALL COLUMNS SIZE SKEWONLY');
  6    dbms_Stats.gather_table_stats('SYS', 'USER$MIG', estimate_percent => 100,
  7                                   method_opt=>'FOR ALL COLUMNS SIZE SKEWONLY');
  8  end;
  9  /
begin
*
ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center