Re: Exporting user's data to new database

So two problems
1 doesn't anything at all because of rollback segment trouble 2 doesn't go to the expected tablespace

1
You don't seem to have (or they are not online) rollback segments. You need to have one additional rollback segment in the tablespace SYSTEM This is for maintenance purposes only, normally it will not be online. Four rollback segments in any other tablespace than SYSTEM. Would result in the following commands
create rollback segment rbtemp
tablespace system
storage (initial 100k next 100k minextents 4); alter rollback segment rbtemp online;
create tablespace rbs
datafile '<anything>' size 128 M
default storage (initial 1 M next 1 M pctincrease 0 minextents 4 maxextents 32);
create rollback segment rbs01
tablespace rbs;
alter rollback segment rbs01
online;
... repeat the last two commands for rbs02 .. rbs04 change or add to initk5ent2.ora in $ORACLE_HOME/dbs the following line
rollback_segments=(rbs01,rbs02,rbs03,rbs04)

2
Assuming the correct tablespace exists check the default tablespace of the user k52. If this is correct check whether the user has the unlimited tablespace privilege (select * from session_privs) or has sufficient quota on the tablespace (select * from user_ts_quotas)

Hope you will succeed now.
Please note your problems have nothing to do with imp, but with a database that's not yet fully operational. We should have addressed that now.

Hth,

Sybrand Bakker, Oracle DBA

• otherwise they will be offline at the next startup Steve . <syarbrou_at_enteract.com> schreef in berichtnieuws f1ovjssb525jn6cmh3bga30qo0fd7u2dmq_at_4ax.com...
  > Ok, read in the book that you can't actually see the table data, so
  > the last question doesn't matter. Did the below and getting what
  > follows:
  >
  > imp k52/k52 file=k5.dmp full=y ignore=y commit=y FROMUSER=k51
  > TOUSER=k52
  >
  > A-01552: cannot use system rollback segment for non-system tablespace
  > 'OEM_REPOSITORY'
  > . . importing table "CBR_SYNONYMS"
  > IMP-00058: ORACLE error 1552 encountered
  > ORA-01552: cannot use system rollback segment for non-system
  > tablespace 'OEM_REPOSITORY'
  > . . importing table "CBR_USER"
  > IMP-00058: ORACLE error 1552 encountered
  > ORA-01552: cannot use system rollback segment for non-system
  > tablespace 'OEM_REPOSITORY'
  > . . importing table "CBR_USERS_IN_GROUP"
  > IMP-00058: ORACLE error 1552 encountered
  > ORA-01552: cannot use system rollback segment for non-system
  > tablespace 'OEM_REPOSITORY'
  > . . importing table "CBR_USER_FILTERS"
  > IMP-00058: ORACLE error 1552 encountered
  > ORA-01552: cannot use system rollback segment for non-system
  > tablespace 'OEM_REPOSITORY'
  > . . importing table "C
  >
  > On Thu, 8 Jun 2000 19:06:53 +0200, "Sybrand Bakker"
  > <postbus_at_sybrandb.demon.nl> wrote:
  >
  > >
  > >Steve . <syarbrou_at_enteract.com> schreef in berichtnieuws
  > >9uevjs4tbstcq33v0ksaouss6mora9qasc_at_4ax.com...
  > >> Ok, I'm running Oracle 8.1.5i on Solaris. The database has two
  > >> database instances on it, named: k51 and k52.
  > >>
  > >> k51 has two additional tablespaces on the drive under:
  > >>
  > >> /usr/oracle8i/u02/cbr_i.dbf
  > >> /usr/oracle8i/u02/cbr_f.dbf
  > >>
  > >> The user that logs into the database is called k5u.
  > >>
  > >> The end users are having problems with that database instance due to
  > >> some SQL script that was run on it. What I want to do is take all the
  > >> data stored in k51 for user k5u, and place it in k52. Of course the
  > >> tablespace needs to be created for k52, but in a different spot of
  > >> course. How do I go about doing this? Also, will I need to recreate
  > >> k5u on the second database, or can I somehow reassociate all the info
  > >> with a user called k5u2 on the the k52 database instance?
  > >>
  > >> Tried exp/imp, but when I did an imp show=y I couldn't find any of the
  > >> data in the dump file that I knew was in the database, like usernames.
  > >> Thanks.
  > >>
  > >> By the way, I have access to the OEM tools if that will help any.
  > >>
  > >> Steve
  > >>
  > >> Newsgroup replies preferred. Remove nospam when replying thru email.
  > >
  > >1 use the create tablespace command prior to importing. Info on the
  original
  > >tablespaces can be found in dba_data_files and dba_tablespaces
  > >2 Use the touser of the imp command to 'move' the data to a different
  user
  > >3 If you made an user export: in that case there will be no create user
  > >statements in the export.
  > >
  > >Hth,
  > >
  > >Sybrand Bakker, Oracle DBA
  > >
  > >
  >