Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Migration Probs

RE: Migration Probs

From: ARUN K C <arun_k_c_at_hotmail.com>
Date: Tue, 13 Jun 2000 12:12:35 PDT
Message-Id: <10527.109050@fatcity.com>


Thank you very much for helping I was too confident of myself that my sys user's tablespace is system,but when Kirti pointed only did I come to know I had made a mistake.
Now it shot like a speeding bullet and the migration was succesfull. Thanks once again for the help cor each one of you arun

>From: "Deshpande, Kirti" <Kirti.Deshpande_at_gtedc.gte.com>
>To: ORACLE-L_at_fatcity.com, arun_k_c_at_hotmail.com
>Subject: RE: Migration Probs
>Date: Tue, 13 Jun 2000 09:09:50 -0500
>
>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
> > solve
> > this
> > Thanks in advance
> > Arun
> >


Received on Tue Jun 13 2000 - 14:12:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US