Getting ORA-01435 while doing a tablespace import
Last updated on OCTOBER 30, 2007
Applies to:Oracle Server - Enterprise Edition - Version: 22.214.171.124 to 10.2.0.3
This problem can occur on any platform.
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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms