On Aug 10, 2006, at 12:29 PM, alfranio correia junior wrote:
One of the great things about Oracle is that they expose a hell of
a lot
of the technology they use to build features like replication; ie:
take
a look at DBMS_*.
If I am not wrong such procedures are only for administrative purpose.
For instance,
we cannot insert things in a queue to be replicated.
No... things like DBMS_PIPE are just general tools that can be used
for anything. My point is that Oracle found they needed functionality
like that do provide a feature they were writing (such as
replication), and said "Well, if we need this, there's probably
others that need it too", so they made it all available. Granted,
they may use some internal interface to it that's faster, but they
still provided it to everyone.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend