What exactly is the ALL_OBJECTS.TIMESTAMP Column? According to the Oracle8i Reference, this character column is the "Timestamp for the specification of the object (character data)".
There...
Hi,
Does anybody have any good way ( a script or something like that) to find out the list of one-off patches applied on an Oracle home. No doumentation or backup patch directories are kept u...
Question:
I want to run a batch file via plsql trigger I have created it in the database. this batch file is opening an Oracle report. I have found this script to use java class to run the ...
Hi,
I have a windoes domain user which was defined on Oracle DB to have access: DOMAIN_X\USER_Y
DB alias = aaprod01
when i'm logined as this user (DOMAIN_X\USER_Y) on the client mechin...
What is the best approach to create a Oracle database using existing datafiles from different server?
Hi,
I'd like to do the following:
ALTER TABLE local_sale_terms
ADD CONSTRAINT constr_check_cancelled
CHECK (NOT EXISTS (SELECT 1
FROM local_sale_terms
...
To create additional databases I have used a script file using external commands in Oracle 8.1.7.
As such svrmgrl have used to run sql scripts.
ie:
spool c:\oracle\ora817\admin\MYDIRC\c...
Dear All,
I am using the following software and versions.
----------------------------
Report Builder 6.0.8.11.3
ORACLE Server Release 8.0.6.0.0
Oracle Procedure Builder 6.0.8.11.0...
I recently got a new laptop and it is running windows xp sp2. I installed Oracle 9i and moved everything off my old one to this one. All settings look identical. The only difference is the ...
ORA-01631 max # extents (505O reached in table ..xyz
Cause: A table tried to extend past MAXEXTENTS.
Action: If MAXEXTENTS is less than the system maximum, raise it. Otherwise, you mus...
Is it possible to manually update the Oracle Universal Installer's inventory?
I am attempting to apply Critical Patch Update Jan 2005 to a 9iAS Rel1 (1.0.2.2) application server. The Relea...
Hello,
My system is a 9.2.0.1.0 database on Windows/XP. I imported an schema and after finishing with it I tried to drop the user. The import came from an 8.1.7.4 system. I even tried to...
Hi,
I'm facing a problem in making reports for Dot Matrix Printers e.g. EPSON. Problem is, I wanna print the report in high speed draft font which is normal a font in any dot matrix printers....
In order to give a middle manager access to the OEM Tool does he have to have the DBA role to sign in to OEM?
I have been noticing this recently in my computer: Eventhough I'm not running any application or program related to ORACLE, oracle.exe gives me high number of memory and virtual memory size.
...
I recently installed the 9.2.0.4 patch on a Oracle 9.2.0.1 database. When using SQL*Plus, I am now receiving a "SP2-0310: unable to open file "filename"" when trying to access any files forme...
I accidently set a parameter to an invalid directory. I shutdown the database before I realized it. When I tried to start the database again I got an error that the parameter in question has a...
Good Morning,
we are having a problem running the call below:
+++++++++++++++++++++++++++++++++++
CREATE OR REPLACE
AND COMPILE JAVA SOURCE NAMED "CONCIERGE"."" RESOLVER ...
I have many UNIX servers with many Oracle instances. When a certain application is run on the database server, it creates a deadlock, which in turn hits a nasty Oracle 9.2.3 bug which corrupts...
I'd need to know the Mac Address of the client to keep a record of changes in some tables I chose, since the IP addresses are dynamic and the terminal name can be modified, it seems to me this...
What is the meanning of this error?
ORA-00600: internal error code, arguments: [17099], [], [], [], [], [], [], []
Tue Oct 19 14:09:15 2004
found dead shared server 'S000', pid = (10, 1...
Hi,
Working Oracle 9 & Linux Red Hat. I cannot access any TEM partitions & the above error are displayed.
At the same time the SYSTEM ROLLBACK statements display a new extension with a ...
We need to install Oracle 10.1.3 Windows 2003. The database data files will reside on an MS1000 SAN Raid 5 disk setup. Our database db block size is 8k. Our db_file_multiblock_read_count is 1...
Hi gang. I recently installed Oracle 10gR2 on an HP-UX box. The install seemed to go smoothly. I started two Oracle instances on a single ORACLE_HOME, and all of my applications are accessi...
Hi Good person,
I have an Oracle DB, that's heavily relying on c-shell scripts, and we need to have a DIRECT link between Oracle scripts and the c-shell scripts. In other words, we want to ...
