Getting ORA-01435 while doing a tablespace import (Doc ID 465053.1)

Last updated on OCTOBER 30, 2007

Applies to:

Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 10.2.0.3
This problem can occur on any platform.

Symptoms

Full export from 9i then full import to 10g results in the following errors:

Following is the output from the import process:
Import: Release 10.2.0.3.0 - Production on Fri Oct 26 07:38:03 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Username:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V09.02.00 via direct path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00046: using FILESIZE value from export file of 5368709120
. importing SYS's objects into SYS
. importing BB_BB60's objects into BB_BB60
"ALTER SESSION SET CURRENT_SCHEMA= "BB_BB60""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms