Reputation
2,240
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
11 35
Newest
 Caucus
Impact
~183k people reached

Jun
24
revised Understanding of schema and tablespaces - recommendation for a later seperation
deleted 8 characters in body
Jun
24
revised Understanding of schema and tablespaces - recommendation for a later seperation
added 855 characters in body
Jun
24
answered Understanding of schema and tablespaces - recommendation for a later seperation
Jun
22
comment Will an update in my trigger trigger itself? Oracle PLSQL
Sounds like a recipe for the error: table is mutating, trigger may not see new state
Jun
22
answered List full text indexes in Oracle database
Jun
19
comment oracle AQ for scheduled jobs
You can use DBMS_LOCK, docs.oracle.com/cd/B28359_01/appdev.111/b28419/… to generate unique names for your locks but the naming will not affect the type of processing. Can you post a test case?
Jun
18
comment oracle AQ for scheduled jobs
I don't know what you mean by "Pulls multiple exclusive locks". Are you referring to code that uses Select for update or Lock table commands? I am unaware of how you would name a lock or how that would help, more details please on the problem
Jun
17
comment oracle AQ for scheduled jobs
I used oracle AQ to receive changes from multiple tables, queue them and then shoot the changes to another database. There were never any issues with the modest amount of transactions I had ( <200/day). What are you looking for: how to set up, how to queue or???
Jun
17
comment How to correct this script restore and recover database on Oracle?
what is the problem when you tried this?
Jun
15
reviewed Approve Moving from Oracle 11.2.0.1 to 11.2.0.3
Jun
15
answered Moving from Oracle 11.2.0.1 to 11.2.0.3
Jun
12
revised Union of data from all tables with name containing a substring
added 140 characters in body
Jun
12
comment Union of data from all tables with name containing a substring
@MelvynDrag There you go, my lesson is don't code from memory, run it through the compiler!
Jun
12
revised Union of data from all tables with name containing a substring
added 35 characters in body
Jun
12
comment Union of data from all tables with name containing a substring
@MelvynDrag what is the characteristic of the tables you don't want?
Jun
12
comment Union of data from all tables with name containing a substring
@MelvynDrag see my edit
Jun
12
revised Union of data from all tables with name containing a substring
added 123 characters in body
Jun
12
answered Union of data from all tables with name containing a substring
Jun
10
awarded  Tumbleweed
Jun
3
asked Pipelined function returning anydataset