Oracle Imp Error 959
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow
Ora-00959 Tablespace Does Not Exist During Import
the company Business Learn more about hiring developers or posting ads with us Stack ora-00959 tablespace does not exist during impdp Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community how to import tablespace in oracle 11g of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up oracle import error up vote 3 down vote favorite While importing a dump file into oracle 11gr2
Ora 00959 Tablespace Users Does Not Exist
i am getting this error please suggest a way to resolve this *Warning: the objects were exported by D7IDMP, not by you import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses WE8ISO8859P1 character set (possible charset conversion) . importing D7IDMP's objects into MIGRATE . . importing table "TXALLTXTS" 245628 rows imported . . importing table "TXAUTH" 377 rows imported . . importing table "TXBAIMERT" 244 rows imported
Remap_tablespace In Imp
. . importing table "TXBARESC" 178 rows imported . . importing table "TXBOILER" 458940 rows imported . . importing table "TXCLASSES" 980 rows imported . . importing table "TXCLOSEDPERIODS" 1 rows imported . . importing table "TXCOMPANIES" 1 rows imported . . importing table "TXCONCLAUSES" 187 rows imported IMP-00017: following statement failed with ORACLE error 959: "CREATE TABLE "TXCONFIGSETTINGS" ("CFS_CODE" VARCHAR2(20), "CFS_RCODE" VARCHAR2(2" "0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 16384 FR" "EELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "MP5TEXT" LOGGI" "NG NOCOMPRESS LOB ("CFS_XMLCONFIG") STORE AS (TABLESPACE "MP5TEXT" ENABLE " "STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536 FREE" "LISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))" IMP-00003: ORACLE error 959 encountered ORA-00959: tablespace 'MP5TEXT' does not exist* As per alex comments i tried with other attributes of imp but it resulted someother error The command which i run is imp fromuser=d7idmp touser=&&from_user file=test.dmp log= test.log ignore=y transport_tablespace = y tablespaces = MP5TEXT the error is import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses WE8ISO8859P1 character set (possible charset conversion) IMP-00053: Import mode incompatible with Export dump file IMP-00000: Import terminated unsuccessfully oracle import oracle11g share|improve this question edited Jun 5 '12 at 10:49 asked Jun 5 '12 at 6:47 Ma
Business solution integration Software modernization (system migration) IT performance management (tuning) IT http://blog.dbi-services.com/how-to-remap-tablespaces-with-oracle-importexport-tool/ service management (ISO 20000 certified) IT training & knowledge transfer Business Intelligence Services Products dbi FlexService - Service Level Agreements (SLA's) Workshops http://dgielis.blogspot.com/2006/05/oracle-export-import-problem-with.html & trainings (dbi InSite) Fixed Price Services Database Management Kit (DMK) References Customer references Testimonials Expertise Areas of expertise Database management does not (RDBMS & NoSQL) Enterprise Content Management (ECM) Application integration & middleware Operating systems Hardware & storage Business Intelligence Partnerships Oracle Platinum Partner Microsoft Gold Partner EMC Documentum Partner Dbvisit Partner EnterpriseDB Partner Severalnines Partner Orachrome Lighty Partner Arcentis Training Oracle workshops Microsoft does not exist workshops Open Source DB workshops Operating system workshops Newsroom Press releases Press images Events dbi services Press articles Newsletter About dbi Company profile dbi people Offices Corporate values & mission dbi xChange dbi InSite workshops Jobs & career Oracle Consultant (m/w) - Basel - Lausanne - Zug/Zürich SQL Server Consultant (m/w) - Basel - Zug/Zürich Imprint Blog Bloggers Categories Tags Contact Offering Services IT systems analysis & design (feasibility studies & audits) Software license management IT system & application implementation Business solution integration Software modernization (system migration) IT performance management (tuning) IT service management (ISO 20000 certified) IT training & knowledge transfer Business Intelligence Services Products dbi FlexService - Service Level Agreements (SLA's) Workshops & trainings (dbi InSite) Fixed Price Services Database Management Kit (DMK) Referen
Import problem with CLOB's I'm currently reorganising some databases…As I do it for the x time, I'm working on "auto-pilot".But suddenly I received an error:--IMP-00003: ORACLE error 959 encounteredORA-00959: tablespace 'TOOLS_DATA' does not existIMP-00017: following statement failed with ORACLE error 959:"CREATE TABLE "D_JOB" ("O_ID" NUMBER(10, 0), "D_TITLE" VARCHAR2(250), "D_OUTPUT" CLOB, "D_PERCENTAGE" NUMBER(10, 0), "D_LASTUPDATE" NUMBER(10, 0), "D_OWNER" NUMBER(10, 0), "D_STATUS" VARCHAR2(20), "D_PRIORITY" NUMBER(10, 0), "D_TYPE" VARCHAR2(20), "D_TIME" VARCHAR2(5), "D_DATE" DATE, "D_CLASS" VARCHAR2(250)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 32768 NEXT 32768 MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TOOLS_DATA" LOB ("D_OUTPUT") STORE AS (TABLESPACE "TOOLS_DATA" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 32768 NEXT 32768 MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))" --What I did:create a full export of the source databasecreate all the necessary users, roles and tablespaces on the target database(use of naming conventions, from dictionary to locally managed tablespace, change of parameters etc.)import from -> to user on the target database(Actually I'm doing the import twice, as the database characterset changed. I create first the structure without data, afterwards change the tables char columns from byte to char and finish with the import of the data)Almost all tables were imported fine, but the tables with some CLOB's in weren't!As I changed the default tablespace of the user (and the old tablespace didn't exist anymore) the import couldn't find the tablespace and gave the above error.I suppose I forgot that if you've tables with clobs in, the default tablespace of the user isn't automatically taken… to solve the problem, I had to recreate the tables manually with the right storage clause (tablespace).I learn a new thing every day (although I think for this, I just forgot this behaviour of Oracle)! ;-) Posted by Dimitri Gielis at