RE: Migration Probs

Make sure the default tablespace for 'sys' is SYSTEM and not USERS. If it is, then change it and try again.  

HTH.
- Kirti

> -----Original Message-----
> From: ARUN K C [SMTP:arun_k_c_at_hotmail.com]
> Sent: Tuesday, June 13, 2000 7:46 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Migration Probs
>
> Hi Dba's,
> I am trying to migrate 7.3.4 to 8.1.6 on sun sparc but in vain,
> when i start the mig utility manually by using
> mig pfile=init.ora it gives an error as below
>
> $ mig pfile=INIT.ORA
> starting up database ...
> mounting database ...
> opening database ...
>
> #^ connect (internal)
>
> drop table grant_mig_priv$;
> create table grant_mig_priv$ (
> name varchar2("M_IDEN"),
> owner varchar2("M_IDEN"),
> grantorname varchar2("M_IDEN"), /* grantor user
> number
> */
> granteename varchar2("M_IDEN"), /* grantee user
> number
> */
> privilege# number not null, /* table privilege
> number
> */
> sequence# number not null, /* unique grant
> sequence
> */
> parent rowid, /*
> parent
> */
> option$ number, /* null = none, 1 = grant
> option
> */
> col# number); /* null = table level, column id if column
> grant
> */
>
>
> insert into grant_mig_priv$
> select o.name,
> u4.name,u1.name,u2.name,privilege#,sequence#,parent,option$,col#
> from objauth$ auth ,user$ u1,user$ u2,user$ u3,obj$ o,user$ u4
> where u1.user# = auth.grantor#
> and u2.user# = auth.grantee#
> and o.obj# = auth.obj#
> and o.type <> 10
> and u4.user# = o.owner#
> and o.owner# = u3.user#
> and u3.name like 'SYS%';
> ORA-01552: cannot use system rollback segment for non-system tablespace
> 'USERS'
>
> Now I have rollback segments which are public and down below and which has
>
> also been specified in the init.ora file.
> Can somebody please let me know as to what is the probs and how I can
Received on Tue Jun 13 2000 - 09:09:50 CDT