Tuesday, April 05, 2005

Debating Skills (JL Comp)

Going over mark rittman's blog i found aother article by jonathan lewis titled can we have a sensible debate.
The debates outlines a couple of thing that are interesting point ot note is the topis iof the thread that jonathan mentions
empirical vs research DBA .
The point in fact that is real world knowledge better or research is the key to sucess.
Hey if someone hadnt proved it to me that i've been wrong i would have still be wrong wouldnt I.
Enjoy
Debating Skills (JL Comp)

� Updateable External Tables

While looking at orasblogsi found this very interesting article about updateable external tables. although i prefer the use of external tables as a good read only medium for my flat file the concept is pretty interesting and could have good implications on some applications.
� Updateable External Tables

10g R2

Bert Scalzo has an interestign post baout 10g r2 and the connect role.
Date: Sat, 2 Apr 2005 19:17:18 -0800
From: "Bert Scalzo"
Subject: FYI - 10g Release 2
Oracle 10g Release 2 is in its third and final beta - and should release
this summer ...
Found my first interesting Oracle 10g Release 2 issue that will effect
lots of people ...
When Oracle 7.0 came out, they created three pre-canned roles (DBA,
RESOURCE, and CONNECT) that were really just short hand notations to
ease people migrating from Oracle 6.0 - but the general recommendation
has always been "NOT" to use these, but rather create your own roles.
Well in Oracle 10g Release 2 they've changed one of these pre-canned
roles - CONNECT. I hate to admit it - but this broke a some of my
scripts. I imagine many other Oracle users will have issues as well.
10g Release 1 and prior - CONNECT had:
GRANT CREATE DATABASE LINK TO CONNECT;
GRANT CREATE SEQUENCE TO CONNECT;
GRANT CREATE SYNONYM TO CONNECT;
GRANT CREATE SESSION TO CONNECT;
GRANT CREATE CLUSTER TO CONNECT;
GRANT ALTER SESSION TO CONNECT;
GRANT CREATE TABLE TO CONNECT;
GRANT CREATE VIEW TO CONNECT;
10g Release 2 beta - CONNECT now only has:
GRANT CREATE SESSION TO CONNECT;
Bert

Google Search