| Thread | Last Post | Replies |
|
| Software to Generate PL/SQL Call Stack?? | 22 Jan 2006 21:35 GMT | 4 |
Hello - I might be living in cloud cuckoo land, but I'm wondering if
there's any way to generate documentation on a PL/SQL package which
will display the full call stack. I imagine it would need some 3rd
party software to parse the source code to display it, but I could be
|
| Installing Oracle 10g on Windows 2003 where the box also acts as a domain controller, install fails with DIM-00019 error | 22 Jan 2006 20:36 GMT | 10 |
I am trying to install the latest version of Oacle 10g onto a windows
2003 box for devlopment purposes. This box also acts as a domain
controller.
Everything gos fine until the the finl DB config stage, the install
|
| iSCSI certification | 22 Jan 2006 15:46 GMT | 2 |
I'm trying to find out if there is some kind of iSCSI hardwrae/vendor
matrix certification for Oracle 10g RAC.
Thanks,
Sagy Volkov
|
| How to perform an exp/imp within a stored procedure? | 22 Jan 2006 13:23 GMT | 3 |
Is there any way to perform an exp/imp from within a stored procedure? Any
built-in package or script?
-Thanks in advance for your attention
|
| How to accomplish this using ONLY one update sentence? | 22 Jan 2006 12:21 GMT | 1 |
There is a table named test1.
it have 2 number fields: field1 field2
the initial value is:
field1 field2
|
| Can I safely get rid of the EXAMPLE tablespace? | 22 Jan 2006 05:04 GMT | 10 |
I used DBCA to create a "general" database, and I noticed a large
(~150MB) tablespace named "EXAMPLE".
Can I safely get rid of that tablespace (to get the 150MB back)? If so,
what's the easiest way to accomplish that?
|
| Domain for stand-alone pc? | 21 Jan 2006 16:49 GMT | 3 |
Trying to install 10g on my laptop which is networked at home to learn about
Oracle. I am trying Standard install. I installed loopback connector but
when I get to step 20 of the procedure it asks for domain name. I am on a
workgroup at home behind a firewall.
|
| statspack Data | 21 Jan 2006 15:01 GMT | 2 |
STATSPACK report for
clsDB Name DB Id Instance Inst Num Release OPS Host
------------ ----------- ------------ -------- ----------- ---
------------
|
| SYSDBA Question | 21 Jan 2006 09:07 GMT | 4 |
Ok, here is a real stopper.......
This shop runs Oracle 9.2 on AIX. It also is running Oracle on the
MAINFRAME!!!!
At any rate, I cannot seem to connect to the mainframe Oracle as
|
| how to multiplex ocr and voting disk | 21 Jan 2006 08:35 GMT | 10 |
When we set up RAC 10gR2 two months ago, we only specified one ocr and
voting disk during the installation. We would like to multiplex those
files now but I'm not able to find the command to do that. How can I
create an additional ocr and voting disk? We're running Solaris9.
|
| ora_psp0_SID process in 10g R2: what is it ? | 21 Jan 2006 01:09 GMT | 1 |
I've noticed a PSPn process: does someone know its purpose ?
(10.2.0.1 on SunOS 9)
Thanks.
|
| Get Free Testking Exams | 20 Jan 2006 23:50 GMT | 2 |
Get Free TestKing Exams At
http://www.testkingcert.com
Rush to register your free Testking Exams at
http://www.testkingcert.com
|
| how to tell RMAN to look at different location for ARCH_LOG backup piece. | 20 Jan 2006 22:40 GMT | 14 |
I need to do a recover , not that urgent.
(my version is 8.1.7.4 32 bit on unix , solaris)
Basically, my production db is running fine except
some users just want one table's information from dec,01,2005
|
| WITH HOLD cursors in Oracle stored procs | 20 Jan 2006 22:10 GMT | 9 |
Is it possible for a stored proc written in PL/SQL to return a
refcursor which is WITH HOLD? I tried the following syntax:
OPEN RS WITH HOLD FOR SELECT...
Any help welcome!
|
| index_stats no populating | 20 Jan 2006 21:38 GMT | 7 |
I'm new to this DBA stuff and I can't seem to get index_stats to
populate. I'm running 9.2.0.5 with the compatible parameter set to
8.1.0, I don't think that should matter though.
I run
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread