Imp-00017 Oracle Error 959
Contents |
Last updated: February 25, 2012 - 5:04 am UTC Category: Database � Version: 9.2.0.7 Latest Followup You Asked I am trying to move objects from one tablespace to another tablespace using export and import. ora-00959 tablespace does not exist impdp Is there any way to avoid the errors below? ORA-01950: no privileges on how to import tablespace in oracle 11g tablespace 'USERS' Thank you for your time. C:\>exp userid=imptest/imp file=exp.dmp Export: Release 9.2.0.7.0 - Production on Mon Jun 26 14:09:39 ora-00959 tablespace does not exist during import 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.7.0 - Production
Imp-00017: Following Statement Failed With Oracle Error 942:
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set server uses US7ASCII character set (possible charset conversion) . exporting pre-schema procedural objects and actions . exporting foreign function library names for user IMPTEST . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user IMPTEST About to export IMPTEST's objects ... . exporting database links . exporting sequence how to create tablespace in oracle 11g numbers . exporting cluster definitions . about to export IMPTEST's tables via Conventional Path ... . . exporting table DEMO_IOT 6091 rows exported . . exporting table MYDBAOBJECTS 0 rows exported . . exporting table NEWS_TEST 0 rows exported . . exporting table T 100 rows exported . . exporting table TESTUNDO 0 rows exported . . exporting table TT 0 rows exported EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. . exporting synonyms . exporting views . exporting stored procedures . exporting operators . exporting referential integrity constraints . exporting triggers . exporting indextypes . exporting bitmap, functional and extensible indexes EXP-00091: Exporting questionable statistics. . exporting posttables actions . exporting materialized views . exporting snapshot logs . exporting job queues . exporting refresh groups and children . exporting dimensions . exporting post-schema procedural objects and actions . exporting statistics Export terminated successfully with warnings. C:\>sqlplus "/ as sysdba" SQL*Plus: Release 9.2.0.7.0 - Production on Mon Jun 26 14:09:55 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.7.0 - Production SQL> drop
2002 10:58 Misha Messages: 25Registered: October 2001 Junior Member during import of the table with BLOB column, I received the following error message: IMP-00017: following remap_tablespace in imp statement failed with ORACLE error 959: "CREATE TABLE "DTPROPERTIES" ("ID" NUMBER(10,
Imp-00058: Oracle Error 1950 Encountered
0) NOT NULL ENABLE, "OBJECTID"" " NUMBER(10, 0), "PROPERTY" VARCHAR2(64) NOT NULL ENABLE, "VALUE" VARCHAR2(2" "55), "LVALUE" BLOB,
Imp-00003
"VERSION" NUMBER(10, 0) NOT NULL ENABLE, "UVALUE" VARCH" "AR2(510)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(IN" "ITIAL 65536) TABLESPACE "NVISDEV" LOB ("LVALUE") STORE AS (TABLESPACE "NVI" https://asktom.oracle.com/pls/apex/f%3Fp%3D100:11:0::::P11_QUESTION_ID:66890284723848 "SDEV" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITI" "AL 65536))" IMP-00003: ORACLE error 959 encountered ORA-00959: tablespace 'NVISDEV' does not exist It's obvious that the error is caused by the NVISDEV tablespace not there... The question is, does anybody knows how to changed the default tablespace for the LOB values? Report message to a moderator http://www.orafaq.com/forum/t/25851/ Re: ORACLE error 959 [message #71662 is a reply to message #71045] Thu, 12 December 2002 09:42 ag Messages: 4Registered: November 2001 Junior Member I got same problem in importing partitioned tables. There are work around like 1) create all necessary tablespaces where the source partition/lob existed or 2) first create the tables and then import. But I was just wondering why Oracle does not import partition/lob's in default tablepspace just like other table/indexes. Report message to a moderator Re: ORACLE error 959 [message #74337 is a reply to message #71045] Wed, 17 November 2004 06:37 Neo Messages: 3Registered: November 2002 Junior Member I have the same problems Same one hane any ide Report message to a moderator Previous Topic: Oracle Work Flow Engine! Next Topic: Urgent. Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication Express, ORDS & MOD_PLSQLFormsReports & DiscovererDesignerJDeveloper, Java
Business solution integration Software modernization (system migration) IT performance management (tuning) IT service management (ISO 20000 certified) http://blog.dbi-services.com/how-to-remap-tablespaces-with-oracle-importexport-tool/ IT training & knowledge transfer Business Intelligence Services Products dbi https://www.experts-exchange.com/questions/22067568/Oracle-exp-imp-error-IMP-00017-IMP-00003-ORA-00959.html FlexService - Service Level Agreements (SLA's) Workshops & trainings (dbi InSite) Fixed Price Services Database Management Kit (DMK) References Customer references Testimonials Expertise Areas of expertise Database management (RDBMS & NoSQL) Enterprise Content Management (ECM) Application integration & oracle error 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 workshops Open Source DB workshops Operating system workshops Newsroom Press releases Press images Events dbi ora-00959 tablespace does 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) References Customer references Testimonials Expertise Areas of expertise Database management (RDBMS & NoSQL) Enterprise Content Management (ECM) Application integration & middleware Operating systems Hardware & storage Business Intelligence Partnerships Oracle Plati
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Oracle exp / imp -- error: IMP-00017 - IMP-00003 - ORA-00959 Want to Advertise Here? Solved Oracle exp / imp -- error: IMP-00017 - IMP-00003 - ORA-00959 Posted on 2006-11-20 Oracle Database 1 Verified Solution 13 Comments 4,673 Views Last Modified: 2012-08-13 When I do an exp of our ORACLE data, then try to imp it as a different user on a different tablespace... I get this error... how can I fix this?? And it only happens on like 3-4 of the 50 tables.... IMP-00017: following statement failed with ORACLE error 959: "CREATE TABLE.... (TABLESPACE "ta" ENABLE STORAGE IN ..." IMP-00003: ORACLE error 959 encountered ORA-00959: tablespace 'ta' does not exist 0 Question by:JoshWegener Facebook Twitter LinkedIn Google LVL 14 Best Solution byanand_2000v then precreate the tables and import with ignore=y option Go to Solution 13 Comments LVL 34 Overall: Level 34 Oracle Database 34 Message Active 1 day ago Expert Comment by:markgeer2006-11-20 Does the tablespace "ta" exist in the database where you run import? If not, create it first. If yes, does the import user have a space quota in the tablespace that allows tables to be created there? 0 LVL 4 Overall: Level 4 Oracle Database 4 Message Expert Comment by:ramumorla2006-11-20 You should create all table spaces that are existing in the source database. 0 LVL 1 Overall: Level 1 Message Author Comment by:JoshWegener2006-11-21 Is there any way to get around this? Some times we load the same data into 3-4 different users (same server) table spaces 0 LVL 14 Overall: Level 14 Oracle Database 13 Message Accepted Solution by:anand_2000v2006-11-21 then precreate the tables and import with ignore=y option 0 LVL 1 Overall: Level 1 Message Author Comment by:JoshWegener2006-11-21 Is there a way I can just export the tables / data i