Plsql Importing tables to Oracle------Import from a table space to another table space

The following issues occurred when importing. dmp files to Oracle with Plsql:

Import started on 2015/11/18 10:42:44
E:\oracle\product\10.2.0\db_1\bin\imp.exe Log=c:\users\lrb\appdata\local\temp\plsimp.log file=e:\work\doc\2015-0 ~1\2015-09-11.dmp userid=lrb/[email protected] buffer=30720 commit=no full=yes grants=yes ignore= Yes Indexes=yes Rows=yes show=no constraints=yes

Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0-production
With the partitioning, OLAP and Data Mining options

Export files created by export:v10.02.01 through the regular path

Warning: These objects are exported by Ansteel, not the current user

import is completed in ZHS16GBK character set and Al16utf16 NCHAR character set
importing the system's objects into the system
IMP-00017: Due to ORACLE error 1119, the following statement failed:
"CREATE temporary tablespace" ansteel_temp "BLOCKSIZE 8192 tempfile ' F:\ORA"
"Cle10g\oracledb\ansteel_temp. DBF ' SIZE 8750M autoextend on NEXT 52428 "
"MAXSIZE 20480M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576"
IMP-00003: Encountering ORACLE error 1119
ORA-01119: Create Database file ' F:\ORACLE10G\ORACLEDB\ANSTEEL_TEMP. DBF ' ERROR
ORA-27040: File creation error, unable to create file
OSD-04002: Unable to open file
o/s-error: (OS 3) The system cannot find the path specified.
IMP-00017: Due to ORACLE error 1119, the following statement failed:
"CREATE tablespace" Ansteel "BLOCKSIZE 8192 datafile ' F:\ORACLE10G\ORACLEDB"
"\ansteel. DBF ' SIZE 1350M autoextend on NEXT 52428800 MAXSIZE 20480M "
"EXTENT MANAGEMENT LOCAL autoallocate ONLINE PERMANENT SEGMENT SPACE MANA"
"Gement AUTO"
IMP-00003: Encountering ORACLE error 1119
ORA-01119: Create Database file ' F:\ORACLE10G\ORACLEDB\ANSTEEL. DBF ' ERROR
ORA-27040: File creation error, unable to create file
OSD-04002: Unable to open file
o/s-error: (OS 3) The system cannot find the path specified.
IMP-00017: Due to ORACLE error 959, the following statement failed:
"CREATE USER" Ansteel "identified by VALUES ' Bc4cc2e793c99e12 ' DEFAULT TABLE"
"SPACE" Ansteel "temporary tablespace" ansteel_temp ""
IMP-00003: Encountering ORACLE error 959
ORA-00959: tablespace ' ansteel ' does not exist
IMP-00017: Due to ORACLE error 1917, the following statement failed:
"GRANT UNLIMITED tablespace to" Ansteel ""
IMP-00003: Encountering ORACLE Error 1917
ORA-01917: User or role ' Ansteel ' does not exist
IMP-00017: Due to ORACLE error 1917, the following statement failed:
"GRANT" CONNECT "to" Ansteel ""
IMP-00003: Encountering ORACLE Error 1917
ORA-01917: User or role ' Ansteel ' does not exist
IMP-00017: Due to ORACLE error 1917, the following statement failed:
"GRANT" DBA "to" Ansteel ""
IMP-00003: Encountering ORACLE Error 1917
ORA-01917: User or role ' Ansteel ' does not exist
IMP-00017: Due to ORACLE error 1917, the following statement failed:
"GRANT" RESOURCE "to" Ansteel ""
IMP-00003: Encountering ORACLE Error 1917
ORA-01917: User or role ' Ansteel ' does not exist
IMP-00017: Due to ORACLE error 1918, the following statement failed:
"ALTER USER" Ansteel "DEFAULT ROLE All"
IMP-00003: Encountering ORACLE error 1918
ORA-01918: User ' Ansteel ' does not exist
. Importing Olapsys objects into Olapsys
. Importing Sysman objects into Sysman
. Importing Ansteel objects into Ansteel
"ALTER SESSION SET current_schema=" Ansteel ""
IMP-00003: Encountering ORACLE error 1435
ORA-01435: User does not exist
IMP-00000: Failed to terminate import successfully

Import finished on 2015/11/18 10:42:46

This is caused by importing from one tablespace to another, and without asteel the user, the workaround:

1. Create a table staging space for the oracle that will be imported

CREATE temporary tablespace ' ansteel_temp ' BLOCKSIZE 8192 tempfile ' F:\ORACLE10G\ORACLEDB\ANSTEEL_TEMP. DBF ' size 8750M autoextend on NEXT 52428800 MAXSIZE 20480M EXTENT MANAGEMENT LOCAL UNIFORM size 1048576

2. Create a tablespace in the future to import Oracle

CREATE tablespace ' Ansteel ' BLOCKSIZE 8192 datafile ' F:\ORACLE10G\ORACLEDB\ANSTEEL. DBF ' SIZE 1350M autoextend on NEXT 52428800 MAXSIZE 20480M EXTENT MANAGEMENT LOCAL autoallocate ONLINE PERMANENT SEGM ENT SPACE MANAGEMENT AUTO

3. Create a user named Asteel and give DBA authority

Plsql Importing tables to Oracle------Import from a table space to another table space