1,765 reputation
627
bio website
location Ottawa.Ontario, Canada
age 55
visits member for 2 years, 9 months
seen Apr 1 at 18:18

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


Jun
8
comment Remote to a remote oracle server and get running instances?
Run scripts without a password? Sounds like a security risk
May
25
revised Move data from one oracle db to another db using toad
added 33 characters in body
May
25
answered Move data from one oracle db to another db using toad
May
8
comment Error while importing a “.sql” file in database
what kind of database?
May
7
answered ORA-12899: importing a .dmp file + character set conversion
May
4
revised Oracle Database Enterprise Users & Roles with Microsoft Active Directory?
added 1 characters in body
May
4
revised Oracle Database Enterprise Users & Roles with Microsoft Active Directory?
added 736 characters in body
May
3
revised Oracle Database Enterprise Users & Roles with Microsoft Active Directory?
added 1408 characters in body
May
3
revised Oracle Database Enterprise Users & Roles with Microsoft Active Directory?
added 3 characters in body
May
3
answered Oracle Database Enterprise Users & Roles with Microsoft Active Directory?
Apr
27
comment Creating Indexes to optimize query
what indexes do you have on MYTAB1 and MYTAB2? This is difficult to answer without more information on the table structure
Apr
19
awarded  Critic
Apr
18
revised ORA-39142: incompatible version number 3.1 error work-around
added 178 characters in body
Apr
18
answered ORA-39142: incompatible version number 3.1 error work-around
Mar
22
comment Import Oracle full dump file to fresh Oracle installation
Sorry I missed that you had a 9i source. You will be forced to use exp and imp commands and physically copy your dump files from one machine to another
Mar
22
revised Import Oracle full dump file to fresh Oracle installation
added 693 characters in body
Mar
22
answered Import Oracle full dump file to fresh Oracle installation
Mar
9
comment How can I allow an Oracle database to be accessed remotely?
and the database is installed on windows or linux?
Feb
16
answered How could sequence.nextval be null in Oracle?
Feb
13
accepted minimum privileges required for a user