2,037 reputation
833
bio website
location Ottawa.Ontario, Canada
age 56
visits member for 3 years, 8 months
seen 2 hours ago

Oracle DBA and programmer with 10 years experience maintaining mission-critical applications. Lots of PL/SQL, C# and the usual glue, vbscript, DOS


1d
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..
2d
comment Populating a table with data from a table that has the historical data on columns (SQL/plSQL 10g)
What have you tried?
Mar
24
comment Unable to open display to specific user in Red Hat 6.4
you also posted the same question on SO stackoverflow.com/questions/29238211/…
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
Mar
12
comment Continuous replication between Oracle Database and Microsoft Azure SQL
what oracle version, how much data are you synching every day?
Mar
7
comment Removing editioning from an Oracle user
Impressive, as they say, I should of thought of that...:)
Mar
4
comment Is it possible to upgrade Oracle 8i to 12c?
@Phil correct but without some idea of the number of users, size of the database files, type of application we are left to speculate
Mar
3
comment Clarification on usage of Serially Reusable Pragma for Oracle 10g
I was never able to get this to work using the Pragma or editioning. If you have a package that you cannot use here and here or here what good is it? I follow best practice and do all changes to production during a time period agreed on by the application owners
Feb
27
comment Best place to keep backup scripts
and in your documentation too with notes on how it works
Feb
27
comment Is EAV an appropriate design for a collection of coexisting metadata-rich “fact estimates” on objects?
double weird, link works in IE (!!!) but not direct from chrome
Feb
27
comment Is EAV an appropriate design for a collection of coexisting metadata-rich “fact estimates” on objects?
link is down for me
Feb
27
comment Why do I get this CMN_1021[ORA-03135: Connection lost to contact
Intermittent network issues?
Feb
27
comment split string into multiple rows with multiple columns
what have you tried?
Feb
26
comment Why am I able to query a remote database without a dblink?
Please show us what script the users use to do this
Jan
29
comment IMPDP twice with same Oracle EXPDP dumpfile with different results?
are you using the consistent parameter in the export? "The exp utility used the CONSISTENT=Y parameter to indicate the export should be consistent to a point in time"
Jan
28
comment How to normalize a table that contains a CK not included in the PK?
I question your assumption that modelName is unique. They can change and are outside your control. Why not just stick with a primary key?
Jan
28
comment optimizing init.ora oracle database server
It's unclear what you are asking. What is the problem?