OraFAQ Forum: Enterprise Manager » creating table wiht 2 columns of type long

Home » RDBMS Server » Enterprise Manager » creating table wiht 2 columns of type long

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

creating table wiht 2 columns of type long [message #68092]

Thu, 31 October 2002 05:50

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

Report message to a moderator

Re: creating table wiht 2 columns of type long [message #68093 is a reply to message #68092]

Thu, 31 October 2002 07:09

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: creating table wiht 2 columns of type long [message #68181 is a reply to message #68092]

Tue, 14 January 2003 00:41

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.

Report message to a moderator

Previous Topic:	VNI-2015 when trying to import/export
Next Topic:	Help: Install and configure Oracle Management server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 13 07:52:01 CST 2025