Home » RDBMS Server » Enterprise Manager » creating table wiht 2 columns of type long
creating table wiht 2 columns of type long [message #68092] Thu, 31 October 2002 05:50 Go to next message
Kivanc Uelguen
Messages: 1
Registered: October 2002
Junior Member
Hi,

how can I create a table with two or more columns of type long?? Is it possible?? Or can only one column per table be defined with datatype LONG??

Thank you!

Kivanc Ülgün
Re: creating table wiht 2 columns of type long [message #68093 is a reply to message #68092] Thu, 31 October 2002 07:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
kivanc
1. FIRST, AVOID USAGE OF LONG. it is desupported.
2. you cannot have two longs in same table. 
   try lobs.
3. if u still insist, there is a clumsy workaround.
   create two tables. of same structure ( with single
   long column.
   store first long column L1 in table T1
   store second long column L2 in table T2.
   have a primary - foreign realtionships between 
  the two.

   

Re: creating table wiht 2 columns of type long [message #68181 is a reply to message #68092] Tue, 14 January 2003 00:41 Go to previous message
vikas
Messages: 29
Registered: November 2001
Junior Member
Mr.Mahesh Rajendran had provide a solution.
But what's the tecnical reason behind that not to use two LONg types in single table.
Previous Topic: VNI-2015 when trying to import/export
Next Topic: Help: Install and configure Oracle Management server
Goto Forum:
  


Current Time: Fri Apr 19 08:08:27 CDT 2024