Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exporting user's data to new database
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'
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
>
>
Received on Thu Jun 08 2000 - 00:00:00 CDT