Re: Migration Probs

I don't think that it's a two step migration. It's only one step as long as you are on at least 7.3.X.

But correct me if I am wrong!

Winnie :)

"Ruth Gramolini" <rgramolini_at_tax.state.vt.us> on 06/13/2000 08:14:50 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Subject: Re: Migration Probs

I think this has to be a two step migration: 1) to 8.0.x and 2) from 8.0.x to 8.1.x. Ruth
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, June 13, 2000 8:46 AM

> 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
>
> --
> Author: ARUN K C
> INET: arun_k_c_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

--
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may