Post reply

Exporting to oracle

  • August 14, 2006 at 3:58 am

    #367075

    I'm having trouble at the moment exporting some sql data to oracle...

    Using the import/export wizard SQL seems to want to put " marks around the database name and table name.

     

    When I remove these " marks the table will create but it will then not move the data across.

    Has anyone ever experienced this when exporting to Oracle before?  and is there a way around it?

  • August 14, 2006 at 9:39 pm

    #654995

    Oracle is case sensitive for table and column names and must be upper case during this type of transfer.  Put the quotes back in and modify the things in quotes to all uppercase.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply