| Import dump [message #471031] |
Thu, 12 August 2010 00:54  |
maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai
|
Member |
|
|
Hi
Please see the session
Import is taken from 10g to 11g.
C:\Users\Administrator>imp system/ace123@orcl[/email] file=d:\17-keystoretab.dmp tables=
KEYSTORETAB log=d:\17-keystoretab.log fromuser=raboit touser=acetemp IGNORE=Y
Import: Release 11.2.0.1.0 - Production on Thu Aug 12 11:29:05 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 RABOIT, not by you
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing RABOIT'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 131072 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "T"
"BS_RABOIT" LOGGING NOCOMPRESS LOB ("KEYSTORE") STORE AS (TABLESPACE "TBS_R"
"ABOIT" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STOR"
"AGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TBS_RABOIT' does not exist
Import terminated successfully with warnings.
Please provide solution
Thanks & Regards
Manish
[Updated on: Thu, 12 August 2010 00:59] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Import dump [message #471054 is a reply to message #471040] |
Thu, 12 August 2010 02:03  |
 |
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Then you still don't undestand all the answers we gave you for the same question.
The answer is the same one.
Each time you will have this error, the answer will be the same one.
Regards
Michel
[Updated on: Thu, 12 August 2010 12:57] Report message to a moderator |
|
|
|
|
|
| Re: Import dump [message #471182 is a reply to message #471086] |
Thu, 12 August 2010 12:50 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
maniatniit wrote on Thu, 12 August 2010 05:35Hi Black Swan
Objects already created
Object name is KEYSTORETAB
Thanks
Manish
Is this a question, and answer or a statement?
If an object already exists with this name, you cannot import it. An import will not move an object from one tablespace to another. I do not know what you are asking or saying.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
