1,897 reputation
731
bio website
location Ottawa.Ontario, Canada
age 56
visits member for 3 years, 3 months
seen 16 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


Jan
10
comment Oracle 11g Rel 2 installation on windows 2008 Server
You have to help me before I can help you. What does the log say? Quote the exact error message.
Jan
10
comment Oracle 11g Rel 2 installation on windows 2008 Server
look in C:\app\product\11.2.0\dbhome_1\YourServerName.YourDomain_YourDatabaseName\sysman‌​\log for emagent.log and emagent.trc
Jan
10
comment Oracle 11g Rel 2 installation on windows 2008 Server
can you show us the install log? I would not assume that just because you get an error when starting Enterprise manager that there is a bug in the software.
Jan
8
comment Log File over 400gigs…need to bring this database back to life
Have you considered that maybe this is a job for someone with more experience? It's not fair to you to try and fix up what appears to be a series of omissions. If you succeed then they will expect miracles again and if not then you get the blame....
Dec
16
comment Applying data changes from one database to another
I'm not clear on the idea of importing data from the development database into production. This seems to break the point of having production and development. What kind of data is this? New properties or characteristics or user entered data?
Dec
10
comment Is it bad idea to create foreign keys on the tables in a different schemas in the same database for big applications?
You can overuse synonyms and further muddy the question of "what does this refer to?". See here for more details on security, performance and best practices stackoverflow.com/a/10042117/851930
Nov
24
comment How to run stored procedure in another database on the same server using a different login?
which database? Sounds like SQL Server...
Nov
7
comment Save a dynamic cursor for reuse?
@MaxVernon I have made the case for two years running. There's money for some things but not for this it seems...
Nov
7
comment Save a dynamic cursor for reuse?
@MaxVernon given that the reporting tool I use is free but crippled it's actually easier to do this in the database
Oct
27
comment Return a fully dynamic table from an Oracle function
@Michael-O the latest release uses Lucene 3.4. see marceloochoa.blogspot.ca/2011/11/…
Oct
26
comment Return a fully dynamic table from an Oracle function
How about embedding the Lucene index in the database.Lucene Domain Index OJVM is still a work in progress but a possible solution that allows you to query with PL/SQL oracle.com/technetwork/database/enterprise-edition/…
Oct
4
comment How to fetch file path from a folder through PL/SQL
windows/linux, what version of Oracle?
Jul
12
comment linked list in SQL and Trees
@ypercube Excuse me! It's all about terms. I should have said a tree structure rather than a linked list.
Jul
12
comment linked list in SQL and Trees
I am currently working on a client report using a linked list. Their question was: Given a grandparent, show all the grandchildren. The SQL is just ugly. The reverse question equally so.
Jul
12
comment linked list in SQL and Trees
I have to work with a linked list type structure in a database and it prompted this question dba.stackexchange.com/questions/36698/… It can be done in a database but it can be difficult to marry the functionality of a linked list with database constraints which enforce integrity
Jun
6
comment Proper Use of Lookup Tables
In my shop the thinkers were able to stop after only four choices, male, female, transgender, would not disclose.
Jun
6
comment Insert into table from a query to a linked database hangs
I would create a view encapsulating your query on the origin database and then query the view. That way you force the join and trimming to be done on the origin database
Mar
19
comment Enforce data integrity with a recursive table
I'm not able to implement all of your solution as it requires changing existing constraints but I can adapt your solution to solve the problem. Thanks!
Mar
15
comment Enforce data integrity with a recursive table
This looks very interesting! I will try it out Monday and report back to see if this answers the question.
Mar
15
comment Database Design question, calculate or save financial positions
I reread your question. You can store the tax amounts as long as you also store a reference to which tax rate was used. Rates go up and down and you need to show the accountants which transactions used which rates.