Varray Problem

2003-12-04 Thread B3D70
Hi there ... I have a table with a Varray Columns. When I used a select operation without access the varray columns the explain plan show fine.. cost = 4 but when I access the Varray columns then I got the cost = 1310 Why ? What happend ? and why oracle did it ? Someone can explain it to me ?

IOT Table on a USERS Tablespace

2003-11-13 Thread B3D70
Hi all I will change some of my table into IOT Table My Question : Is it ok to store my IOT Table into Users Tablespace or shoud I store in a new tablespace ..just to hold all IOT Table ? regards kang bedjo -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: B3D70 INET

Re: Constraints

2002-04-24 Thread B3D70
rather see the world from another angle *- Jewel- * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: B3D70 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California