| Importing a dump [message #470452] |
Tue, 10 August 2010 01:07  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
