I'm getting errors when importing into an 8.1.5 database from the same version export. What do these messages mean?
ORA-1543 signalled during: CREATE TABLESPACE "ABC" DATAFILE '/ed02/orada
ORA-1535 signalled during: CREATE PUBLIC ROLLBACK SEGMENT R01 STORAGE (INITIAL...
These objects are up and running and don't seem to be having any problems.
You must have performed a full export (FULL=Y) of your source database followed by a full import (FULL=Y) to your destination database. When you do this, the export dump file will contain the DDL statements to create your tablespaces and rollback segments. And the full import will attempt to create those tablespaces and rollback segments. You get the ORA-1543 error because the tablespace ABC already exists in your destination database. And you get the ORA-1535 error because the rollback segment R01 alread exists in the destination database. Since they already exist, there is no harm done. The above errors are more informational than a real problem.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.