Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: imp73 --> creation of Rollback segments, but not setting them online...
Reinol Beyer escribió:
> The .dmp file creates all tablespaces, users and the rollback segments,=
but
> doesn't set them online... so when the .dmp file tries to insert data, =
the
> error occures "can't use system rollback segment for non-system table .=
..".
> =
> Is this common, or did I forget something?
Have you re-started your instance. If so, have you specified in your
init.ora the rollback segments?
rollback_Segments=(rbs_1,rbs_2,...)
=
> Anyway, after setting them online and running the import again, it work=
s...
> but there are LOADS of errors concerning some constraints in system tab=
les
> being invalid and problems compiling something... what's that???
It's something normal because, for example, may be your trying to
compile a function anf the tables referenced haven't been imported yet,
or some foreign key, or....
I sotrngly recommend you to recreate the db and create all objects from
the creation script files and finally import every data (with the ignore
option = y) from the dump file, user by user.
If you dno't have the scripts for creating db objects then you should
follow these steps:
1.- create the db manually
2.- Import the indexes to a text filen not to the database (see Server
Utilities User's Guide)
3.- import objects without importing data as many times as neccessary.
Set the ignore option to yes and, if getting any errors, never mind
import the objects again (if they already exist). I know it sounds
horrible but IT WORKS. Although, if your db is very big I don't
recommend you. This way, first time you enssurance to create tables and
primary kews; second time create views to this, functions, other
tables;... Repear this step till no errors got.
4.- Import the data
5.- Create indexes from the text file.
=
> What can I do?
> Thanx in advance
> Reinold
Hope this help.
-- =
Julio Negueruela
DBA Servicio Informático
Universidad de La Rioja - Spain Telf: 941-299179 Fax: 941- 299180