Copying a table with LONG
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Copying a table with LONG

  1. #1
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    Hi gurus,

    I need to copy a table from one schema to another.

    This table has a LONG datatype column.

    What is the best way to do this?

    Thanks!
    Hemant

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    a) export/import
    b) SQL*Plus COPY command
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    Thanks Jmodic!

    I did hear that there are problems in exp/im with a LONG though.

    Is there any resource you could point me to for more info on this?

    Thanks again!
    Hemant

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Here are the known restrictions on LONGs. There should be no big problems with their export or import.

    *Only one LONG column allowed per table
    *LONG column cannot be indexed
    *LONG columns cannot appear in integrity constraints
    *LONG columns cannot be used in WHERE,GROUP BY,ORDER BY, or CONNECT BY clauses, or with the DISTINCT operator in SELECT statements.
    *LONG columns cannot be used referenced by SQL functions (such as SUBSTR or INSTR).
    *LONG columns cannot be used in the SELECT list of a subquery or queries combined by set operators (UNION, UNION ALL, INTERSECT, or MINUS).
    *LONG columns cannot be used in SQL expressions.
    *LONG columns cannot be referenced when creating a table with query (CREATE TABLE...AS SELECT...) or when inserting into a table(or view) with a query (INSERT INTO ... SELECT...).
    *LONG columns cannot be referenced in a sub-query A variable or argument of a PL/SQL program unit cannot be declared using the LONG datatype.
    *A LONG or LONG RAW column can be referenced in a SQL statement within a trigger if the data from a LONG or LONG RAW column can be converted to a constrained datatype (such as CHAR and VARCHAR2).
    *Variable cannot be declared using the LONG or LONG RAW datatypes.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

Posting Permissions

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



Click Here to Expand Forum to Full Width