Migration Probs

From: ARUN K C <arun_k_c_at_hotmail.com>
Date: Tue, 13 Jun 2000 04:40:20 PDT
Message-Id: <10527.108882@fatcity.com>

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 solve this
Thanks in advance
Arun

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com Received on Tue Jun 13 2000 - 06:40:20 CDT