Q
Problem solve Get help with specific problems with your technologies, process and projects.

Errors when importing from same version

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.

This was last published in February 2004

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close