4 Replies Latest reply: Feb 21, 2013 3:43 AM by Venkateshj RSS

    Reg:- Import- Oracle 11g R2

    Venkateshj
      Hi all,

      I have a Table Name as MAPS
      CREATE TABLE MAPS (
      MAPNAME VARCHAR(35),
      MAPFILENAME VARCHAR(35),
      LEFTSTATION VARCHAR(25),
      RIGHTSTATION VARCHAR(25),
      MAPINDEX INTEGER,
      MAPCHKSUM INTEGER,
      MAPFILE BLOB SUB_TYPE 0 SEGMENT SIZE 80
      );

      In this maps table i hav some data related to BLOB datatype..

      Now am exporting maps table from user "UBLBRANCH" and then while importing the exported maps table into another user "OE" which is in the another Database, but Same Oracle Versions of both Databases.

      Am Getting a error as below

      C:\>imp

      Import: Release 11.2.0.1.0 - Production on Wed Feb 20 09:53:38 2013

      Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

      Username: oe/oe@1

      IMP-00058: ORACLE error 1017 encountered
      ORA-01017: invalid username/password; logon deniedUsername: oe/1@1

      Connected to: Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

      Import data only (yes/no): no >

      Import file: EXPDAT.DMP > C:\ublbranch_Skel_2013_02_12_ManualDump

      Enter insert buffer size (minimum is 8192) 30720>

      Export file created by EXPORT:V10.01.00 via conventional path

      Warning: the objects were exported by UBLBRANCH, not by you

      import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
      List contents of import file only (yes/no): no >

      Ignore create error due to object existence (yes/no): no >

      Import grants (yes/no): yes >

      Import table data (yes/no): yes >

      Import entire export file (yes/no): no >
      Username: oe/1

      Enter table(T) or partition(T:P) names. Null list means all tables for user
      Enter table(T) or partition(T:P) name or . if done: maps

      Enter table(T) or partition(T:P) name or . if done:

      . importing UBLBRANCH's objects into OE
      . importing UBLBRANCH's objects into OE
      IMP-00017: following statement failed with ORACLE error 959:
      "CREATE TABLE "MAPS" ("MAPNAME" VARCHAR2(30), "MAPFILENAME" VARCHAR2(30), "L"
      "EFTSTATION" VARCHAR2(20), "RIGHTSTATION" VARCHAR2(20), "MAPINDEX" NUMBER, ""
      "MAPCHKSUM" NUMBER(*,0), "MAPFILE" BLOB) PCTFREE 10 PCTUSED 40 INITRANS 1 M"
      "AXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL"
      " DEFAULT) TABLESPACE "UBLBRANCHTBS" LOGGING NOCOMPRESS LOB ("MAPFILE") STOR"
      "E AS (TABLESPACE "UBLBRANCHTBS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSIO"
      "N 10 NOCACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_PO"
      "OL DEFAULT))"
      IMP-00003: ORACLE error 959 encountered
      ORA-00959: tablespace 'UBLBRANCHTBS' does not exist
      IMP-00034: Warning: FromUser "OE/1" not found in export file
      Import terminated successfully with warnings.

      C:\>



      Please give a solution why it occurrs?