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


Dec
18
comment Read ancient Oracle database into current Oracle version
I believe you can still download 9i which is not too far from 8. If this is worth the time you could install 9i on a test box and see if the files are recognized.
Nov
29
comment Software tool to visualize and print DB diagrams
I like the data modeler from Oracle. It's not Erwin but it can do a lot of what you need
Nov
25
comment Force number precision in a view with Union
good answer, using CAST on the overall select works fine and gives a view with the column precision of NUMBER(1).
Nov
25
comment Oracle Enterprise Manager font problem, some text is displayed in Chinese and with squares
was it always like this or is this a new install?
Nov
23
comment Force number precision in a view with Union
I am away from my desk but that looks interesting. What is the precision when you run it?
Nov
23
comment Force number precision in a view with Union
Sorry Phil, the desired result is NUMBER(1)
Nov
5
comment Pitfalls of creating a foreign key constraint on a system table?
@Phil please submit your comment as an answer and I'll do so
Oct
25
comment Oracle Enterprise Manager 11g dbconsole “Internet Explorer cannot display the webpage”
Is it possible that the required apex tables or users have removed or have locked accounts
Oct
25
comment oracle how to call procedure
Create new schema, import the data into that schema using the old export/import or the datapump which I think will work from self to self. Then, in the new schema, redefine your fields and do the ORM from there. But if you continue to work with the original schema you will have pain later. Best way is to redefine the original schema but this must be tested!
Oct
25
comment oracle how to call procedure
better yet ask another question about migrations
Oct
25
comment Data archival strategy that handles schema changes?
"a substantial schema change every quarter" Yikes! Could indicate that the existing schema is badly designed. I grant it's not relevant to your question though.
Oct
15
comment Why an object became invalid in oracle databse.
changing the parameters in procedures and functions in packages or just recompiling stand alone procedures will do it to.
Oct
7
comment How do you document your databases?
requires .NET Framework 4.0 and only works with SQL Server and SQL Express
Oct
2
comment What are the things need to be considered while creating tablespace?
why not use the default tablespace until you can show there is a problem? When you create a database the Oracle default settings are quite reasonable and it makes it much easier to administer a database created this way. Said another way "If it's not broken, don't fix it."
Oct
2
comment Trying to copy a schema using impdp
Quite right, the data pump should work, but doesn't for the OP. They noted "I'm also open to other ways to clone a schema." and this answer will do the job.
Sep
27
comment How to install Oracle 10g Express and 11g Enterprise on same machine
I could create a folder on the 8i machine and then map that as a directory for the 11g database and then write csv files to it but this is not an optimal solution. You would need extra tables to log what was entered. Unfortunately I have views of tables on the 8i database that I did not mention that are used for other transactions on the 11g.
Sep
25
comment how do I configure a new Oracle 11g instance to match the configuration of the old Oracle 10g server
before you think about changing parameters what are the problems you are trying to address? A default install of Oracle does a pretty good job for many uses.
Sep
21
comment How to install Oracle 10g Express and 11g Enterprise on same machine
It's easier if they run on the same machine. It could be done with a regular 10g and 11i so it seems possible with express.
Sep
16
comment Can this business logic be enforced by a conditional database constraint?
Fabulous, I ran into this with another MV but only saw adding a constraint as a problem not a solution
Sep
14
comment Can this business logic be enforced by a conditional database constraint?
I will have to document this internal rule that other databases connecting to this one must use a database link with a custom user who only has rights to execute packages, not to insert directly. Thanks