Home » RDBMS Server » Server Utilities » Import dump (Windows)
Import dump [message #471031] Thu, 12 August 2010 00:54 Go to next message
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 #471033 is a reply to message #471031] Thu, 12 August 2010 00:57 Go to previous messageGo to next message
BlackSwan
Messages: 22547
Registered: January 2009
Senior Member
>ORA-00959: tablespace 'TBS_RABOIT' does not exist
create missing tablespace
Re: Import dump [message #471039 is a reply to message #471033] Thu, 12 August 2010 01:09 Go to previous messageGo to next message
maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai
Member

Hi

No i want in my tablespace "acetemp"

Re: Import dump [message #471040 is a reply to message #471039] Thu, 12 August 2010 01:11 Go to previous messageGo to next message
BlackSwan
Messages: 22547
Registered: January 2009
Senior Member
maniatniit wrote on Wed, 11 August 2010 23:09
Hi

No i want in my tablespace "acetemp"


then pre-create objects in it
Re: Import dump [message #471054 is a reply to message #471040] Thu, 12 August 2010 02:03 Go to previous messageGo to next message
Michel Cadot
Messages: 58638
Registered: March 2007
Location: Nanterre, France, http://...
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 #471086 is a reply to message #471040] Thu, 12 August 2010 04:35 Go to previous messageGo to next message
maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai
Member

Hi Black Swan

Objects already created
Object name is KEYSTORETAB

Thanks
Manish
Re: Import dump [message #471182 is a reply to message #471086] Thu, 12 August 2010 12:50 Go to previous messageGo to next message
joy_division
Messages: 4490
Registered: February 2005
Location: East Coast USA
Senior Member
maniatniit wrote on Thu, 12 August 2010 05:35
Hi 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.
Re: Import dump [message #471183 is a reply to message #471182] Thu, 12 August 2010 12:57 Go to previous messageGo to next message
Michel Cadot
Messages: 58638
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I do not know what you are asking or saying.

Maybe you could have an idea from his 2 previous topics on exactly the same problem.

Regards
Michel
Re: Import dump [message #471413 is a reply to message #471183] Sat, 14 August 2010 02:00 Go to previous messageGo to next message
maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai
Member

Hi Black Swan,

I want to import a data of that table in Keystoretab table and i m using ACETEMP tablespace. i dont want to create a table.

Thanks & Regards
Manish
Re: Import dump [message #471414 is a reply to message #471413] Sat, 14 August 2010 02:06 Go to previous message
Michel Cadot
Messages: 58638
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So do it.

Regards
Michel
Previous Topic: Known bugs AWR Report and Snapshots?
Next Topic: Triggers does not fired while doing import in oracle9i
Goto Forum:
  


Current Time: Thu Jul 31 17:11:04 CDT 2014

Total time taken to generate the page: 0.15644 seconds