Re: 8.0.5 (linux) export to 8i (linux) import problems...

A copy of this was sent to "Chad D. Wessel" <cwessel_at_iname.com> (if that email address didn't require changing) On Sun, 14 Nov 1999 10:29:15 -0500, you wrote:

>i did a full export of my 8.0.5 linux (redhat 5.2) database, but when i try
>to import to the 8i linux(redhat 6) i get the following error:
>
>ORA-01552: cannot use system rollback segment fro non-system tablespace
>'USERS'
>

you need to add rollback segments to your 8i instance. Or, if you had added them, you need to bring them online (and add them to your init.ora file so they are brought online each time the db is started).

To see if you have them already

tkyte_at_8i> l
  1 select segment_name, status from dba_rollback_segs where   2* tablespace_name <> 'SYSTEM'
tkyte_at_8i> /

SEGMENT_NAME                   STATUS
------------------------------ ----------------

If this comes back with 0 rows -- add some rollback segments to your instance and alter them online. For example:

create rollback segment rbs01 tablespace some_table_space storage(initial 1m next 1m minextents 2 );
create rollback segment rbs02 tablespace some_table_space storage(initial 1m next 1m minextents 2 );

alter rollback segment rbs01 online;
alter rollback segment rbs02 online;

that'll create the 2 rollback segments we want and bring them online.

You should also add to your init.ora (typically found in $ORACLE_HOME/dbs/init$ORACLE_SID.ora) the following:

rollback_segments = (rbs01, rbs02)

You'll have to create the tablespace 'some_table_space' ....

>it appears to import everything but the rows. does anyone know of a
>solution?
>
>chad

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun Nov 14 1999 - 09:48:36 CST