blum's articles:

Items(2) /1

OO-databases - anyone out there? 6 30 (6/17/2007 5:02:17 PM) comp.databases.oracle.server Hello, Several times I've been asked, if there are any object-oriented databases having relevance to the IT market. IMHO there is no such OO-database-product, which can mess with RDBMS products (Oracle, MS-SQ... Marc

INSERT...SELECT...FROM TABLE(object-collection) slow 3 21 (2/16/2006 9:02:30 PM) comp.databases.oracle.server Hi, we (sorrily) found out, that a INSERT INTO SELECT FROM TABLE (collection of object type) is rather slow. When recoding the logic with PL/SQL-tables, many loops and FORALL INSERTs, we got performance ga... Marc

blum's replies:

Items(27) /3 Next >> Last >|

Reporting Oracle Bugs Question 6 41 (11/20/2005 6:32:29 AM) comp.databases.oracle.server Hello Fellow Oracle Users, Is there a way to report possible Oracle bugs to Oracle without having an Oracle license? I am testing the free evaluation download products from OTN, and I have been told that in ... alvarofuentes (7)

INSERT...SELECT...FROM TABLE(object-collection) slow 3 21 (2/16/2006 9:02:30 PM) comp.databases.oracle.server Hi, we (sorrily) found out, that a INSERT INTO SELECT FROM TABLE (collection of object type) is rather slow. When recoding the logic with PL/SQL-tables, many loops and FORALL INSERTs, we got performance ga... blum (48)

how to find unused table /columns in a database 13 39 (3/16/2006 9:44:34 AM) comp.databases.oracle.server hello we are using oracle 9i production database and d2k 6i applications. is there any way by which i can find the tables/ columns that are not in used by applications. So that i can move them out from our p... gpanda28 (7)

Why does oracle support suck so much? 15 77 (4/27/2006 6:22:45 PM) comp.databases.oracle.server Over the years I have learned to rely less and less on oracle support, because quite often you get someone who is either incompetent or thick-headed. Thanks to this group, asktom website and many other useful o... netcomradeNSPAM (497)

add field in PK 5 37 (4/27/2007 12:17:34 PM) comp.databases.oracle.server can i add a field on an existing primary key ? thanks ... luca001 (3)

Do you use PL/SQL 60 38 (5/20/2007 3:02:52 AM) comp.databases.oracle.server I will be teaching a PL/SQL class, and I wanted to get some opinions. I read about PL/SQL, but wanted some practical advice from people who have used it. 1. Why use PL/SQL instead of just sending SQL queri... douglass_davis (53)

OO-databases - anyone out there? 6 30 (6/17/2007 5:02:17 PM) comp.databases.oracle.server Hello, Several times I've been asked, if there are any object-oriented databases having relevance to the IT market. IMHO there is no such OO-database-product, which can mess with RDBMS products (Oracle, MS-SQ... blum (48)

Global Temp Table (PRESERVE ROWS) truncating unexpectedly 3 34 (9/23/2007 2:16:51 AM) comp.databases.oracle.server I love "GLOBAL TEMPORARY TABLEs" (GTT). I have been using them for awhile, and find them to be a great tool. We are rac'ed but I am logging into one specific instance. My IDE is pl/sql developer version 7.1.2... pmmgpgp (4)

why administrator refuse to give permission on PLUSTRACE 86 45 (10/26/2007 12:21:48 PM) comp.databases.oracle.server why our DBA refuse to give us permission on PLUSTRACE ??? does that role expose the database to any security flaw ??? I need to set the AUTOTRACE to understand how the sql script is functionning, but our DBA re... antony6670 (10)

Oracle managed statistics 9 26 (10/31/2007 7:00:28 PM) comp.databases.oracle.server Once again I turn to the gurus. I have a vendor who is nervous about the Oracle managed statistics (target object auto). They don't like seeing objects with statistics older than a month. My choices are: 1) F... silverback (17)