Reputation
2,604
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
15 37
Newest
 Revival
Impact
~247k people reached

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
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
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
1
comment number field in varchar2 field
I feel the pain of a bad database design
May
20
comment Passing filter params to a sub query
do you want to change the parameters of the view on demand? What you have will create a view which does not change unless the underlying data is changed. If you want to adjust the parameters then a cursor would do. Please clarify what you want to do, what is the problem you want to solve?
May
20
comment Passing filter params to a sub query
do you want to change the parameters dynamically, in which case a view is not the object of choice, or....
May
5
comment Tune Performance by putting large tables into the KEEP Pool
I think you would get more success by optimizing the queries than putting tables in memory
May
4
comment TNSNAMES.ORA is located in Windows 2012 Server
Could be a lot of places depending on whether the install was standard or custom. Windows search will find how many versions you have
Apr
22
comment I have a table from which I can retrieve information but I cannot update or delete information
what database and what version? Do you have rights to update and delete but not select for that table?
Apr
20
comment Do data types go into a Relational Data Model (RDM)?
Most people like the lines between tables to not cross. takes more work but even a large diagram can be a thing of beauty if you take the time.
Apr
1
comment Oracle: Create a hidden user for RMAN backups only
You should ask a new question about how to do RMAN backups complete with the details of what storage you have available to back up, how big is the database, what is the expectation for loss of data (ie unwilling to loose more than an hour of data entry implies taking backup and moving logs off the server every hour)
Mar
31
comment Oracle: Create a hidden user for RMAN backups only
so what happens when you open a command line and type in RMAN when logged in as a user who is a member of ORA_DBA?
Mar
26
comment how to prevent any update to my database before a exp operation?
well you could do that for every user except SYS, SYSDBA but then existing sessions would still continue to run and someone could still log on who was in the ORA_DBA group (windows OS) and connect as sys, and jobs would still run..
Mar
20
comment migration of oracle xe 10 to xe 11 fails with wrong paths used in the import
I don't suppose just exporting or datapumping the schemas you are interested in rather than a full export will work?
Mar
18
comment EAV table question
It all depends.... how many entries, your budget for hardware and software or is this a thought experiment? Either way the amount of space a single table occupies versus several tables is not a determining factor in the speed of a query.
Mar
18
comment Failed to connect to oracle SQL Plus
@roukaya from your answer you know how to shutdown and restart the database. Did this solve your problem?
Mar
14
comment Removing editioning from an Oracle user
@Phil Post your test case and I will accept it as the answer