Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    50

    Arrow Unanswered: can i rename a table while importing it?

    Hi,
    can i rename a table while importing it?

    Thanks,
    Ishan

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    no, you can't rename a table while the import hasn't finished on that table

  3. #3
    Join Date
    Mar 2004
    Posts
    50

    Arrow

    Hi,
    What I wanted to ask was that I have exported a table with name X. Can I import it as table Y ?. (There is already a table in my schema with name X, so I want to rename the new table while importing it.)

    Thanks,
    Ishan

  4. #4
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    I believe the answer is still no. You do not give any version info, but even looking at the latest doc I did not see an command to do so. I only did a brief look, you might want to dig deeper. http://download-west.oracle.com/docs...a96652/toc.htm

    It might be fast to just rename the existing table, import, then rename the imported file and rename the existing file back (or however you want to maintain your table names).
    NOTE: Please disregard the label "Senior Member".

Posting Permissions

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