Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2005
    Posts
    40

    Unanswered: IMP-00033 ERRORS when table is CLEARLY in exp dmp file

    I am importing from the exact same database 9.2 to a 9.2 database on a different server.
    Please help me! I am trying to import 7 tables from a FULL=Y exp dmp file but I keep receiving the error, IMP-00033 because the tables I am trying to import are in mixed case. I have tried putting quotes around the tables, and using the \ before the parenthesis and none of this works. Metalink has very little info out there BUT to do what I have already done. I know the tables are in the exp file because I have the log.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    First of all, congratulations on choosing mixed-case table naming convention! (not!)

    Try with
    Code:
    IMP un/pw@db FILE=exp_file.dmp TABLES='\"Table_NamE\"'
    (single quote - backslash - double quote - table name - backslash - double quote - single quote)

  3. #3
    Join Date
    Aug 2005
    Posts
    40
    Actually, I did not choose the mixed case, the dba before me did. I just started this job and saw this. I was like wow! Thank you, I will try this.

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Your previou DBA wasn't much of a DBA. JMO
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •