Home » RDBMS Server » Server Utilities » Importing a dump (Windows)
Importing a dump [message #470452] Tue, 10 August 2010 01:07 Go to next message
maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai
Member

Hi
Please check the session
=================================================

C:\>imp acetemp/acetemp@orcl file=C:\oracle\06-update-initial-data-scripts\17-ke
ystoretab.dmp log=17-keystoretab.log tables='KEYSTORETAB' fromuser=RABOINTO tous
er=ACETEMP IGNORE=Y DESTROY=N

Import: Release 11.2.0.1.0 - Production on Tue Aug 10 11:40:15 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.02.01 via conventional path

Warning: the objects were exported by RABOINTO, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export server uses UTF8 NCHAR character set (possible ncharset conversion)
. importing RABOINTO's objects into ACETEMP
IMP-00017: following statement failed with ORACLE error 959:
"CREATE TABLE "KEYSTORETAB" ("KEYSTORE_ID" VARCHAR2(25) NOT NULL ENABLE, "RE"
"SERVED_BY" VARCHAR2(15), "UPDATE_DATE" DATE, "VERIFIED_BY" VARCHAR2(15), "V"
"ALIDATED_BY" VARCHAR2(15), "STATUS" LONG NOT NULL ENABLE, "KEYSTORE_PASSWOR"
"D_PART" VARCHAR2(100), "KEYSTORE_PASSWORD" VARCHAR2(100) NOT NULL ENABLE, ""
"KEYSTORE" BLOB) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INIT"
"IAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RA"
"BOINTO" LOGGING NOCOMPRESS LOB ("KEYSTORE") STORE AS (TABLESPACE "RABOINTO"
"" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE(INITI"
"AL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'RABOINTO' does not exist
Import terminated successfully with warnings.

=====================================================
Please provide a sollution

Thanks
Manish
Re: Importing a dump [message #470458 is a reply to message #470452] Tue, 10 August 2010 01:13 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
ORA-00959: tablespace 'RABOINTO' does not exist

So, create it before performing import.
Previous Topic: Error in executing ODCIEXTTABLEOPEN
Next Topic: Flashback in Oracle 11g
Goto Forum:
  


Current Time: Thu Mar 28 10:13:28 CDT 2024