Re: LONG RAW versus BLOB performance

Oracle has also recommended not using LONG in new applications since Oracle8 See http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adfns typ.htm#427094. Cheers, John Thomas In message [EMAIL PROTECTED], Jared Still [EMAIL PROTECTED] writes Mark, Have you also considered

Re: Implementing different document types with different attribut

to build our table-structure? I've heart something about FlexFields, what are they? Takes every field diskspace, even if it's blank (null)? Thanks in advance for the response! Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- John Thomas -- Please see the official ORACLE-L FAQ: http

Re: Implementing different document types with different attributes

Tim, Are you using 9i? If so create a parent_t object type with the common attributes. Create child object types UNDER parent_t. You can then define a table of type parent_t able to accept rows of all types. Cheers, John Thomas In message [EMAIL PROTECTED], Vernaillen Tim [EMAIL PROTECTED

Re: [Q] ORACLE 9i remote export insufficient previlege?

(or was it databases?) using the same file to log in remotely as well... Cheers, John Thomas In message [EMAIL PROTECTED], dist cash [EMAIL PROTECTED] writes I am doing the ORACLE 9iR2 database test and tried to export form a 8i computer to 9iR2 server. I got ORA-01031: insufficient privileges. my export

Re:

? David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- John Thomas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Data modeling question about reference table

performance without indexes... like I say, just depends.) Cheers, John Thomas In message [EMAIL PROTECTED], paquette stephane [EMAIL PROTECTED] writes Hi, We're discussing on reference table. One containing everything (using a type) or one per entity. We'll have a lot of entities

Re: insert nologging parallel/noparallel and archiving

information (like subscribing). -- John Thomas Tel:01506 881 037 Oracle Contract DBA Mobile: 07986 182 368 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Thomas INET: [EMAIL PROTECTED] Fat City

Re: Oracle Trial License

or anyone elses. I think the terms you were quoting refer to Trial licences from www.oracle.com's shop, not OTN. Cheers, John Thomas In message [EMAIL PROTECTED], Alexandre Gorbatchev [EMAIL PROTECTED] writes Here is the quotes: . Trial Programs Included With Orders We may include additional

Re: How to insert Special Characters ?

blablabla SQL spool off Cheers, John Thomas Contract Oracle Development DBA (currently available

Re: how to use multiple ref cursors

. Cheers, John Thomas Oracle development DBA (available for contract performance analysis and just about anything else.) ticle [EMAIL PROTECTED], Fedock, John (KAM.RHQ) [EMAIL PROTECTED] writes Currently we have some stored procedures that hand a ref cursor back to a call from the Microsoft

Re: What's in PGA ?

Frédéric, This may be a long shot, but have you got PL/SQL tables in use? They extend forever in a heap unless you use DBMS_SESSION.FREE_UNUSED_US ER_MEMORY. My experience is that use of this call uses so much CPU it outweighs the advantages of using PL/SQL tables. Cheers, John Thomas

Re: Table Naming Conventions

Singular. On the grounds that almost every table is a collection of things/contains multiple rows. So the S would be superfluous, except for things like SHEEP. Cheers, John Thomas Oracle development DBA In article [EMAIL PROTECTED], Gary Chambers [EMAIL PROTECTED] writes Many thanks