I am running an rman backup scheme with a level "0" incremental backup on Sunday and level "1" incremental throughout the week in a unix enviroment (oracle 9i). However I don't have enough sp...
I need to pivot some data in my query and the way I am doing it seems to work, but I want to make sure I can get consistent results. I have 2 tables of data with a common key, so here is the ...
While installing Oracle client 9.2.0.1.0 on windows XP Proffesional, I got an error:
StartIndeterminate_OS_ErrorException
Here is the log output from installActions2007-08xxx
**********...
Hello
I got the solution already but I wonder why I have to take this way: I have a DB link that can be created directly (f.e. SQL-Plus) and it's working fine. Lets say the creator us user SC...
ORA-01555 caused by SQL statement below (Query Duration=3 sec, SCN: 0x02ee.609081d9):
SELECT OBJECT_OWNER,OBJECT_NAME,OPERATION_NAME,USER_PROCEDURE,DECODE(ERROR_HANDLER,'Y',1,0) FROM DBA_AP...
Hi guys,
Would you please help me out to understand UPDATE syntax in Oracle 9i.
I need to update selected rows in a table.
In SQL Server it would be something like this:
update Tab...
Hi Guru
I have a fresh install of Oracle Client 9.2 and Oracle Database 9.2 on my Windows XP SP2 machine.
My machine is called LAXP001, the Net Service Name is DEVL, the Database is DEVDB, ...
Oracle query must include Schema name? i.e. Select * from SCHEMA.TableName?
How do I ensure that I can use Select * from TableName instead?
Please advise, thanks.
I'm trying to deploy something in a production environment (actually for QA), where the SysAdmins and DBAs are in a different time zone and I have limited ability to see what's going on. The R...
I recevied an export DMP file that was created with rows=n. I am importing that DMP file via IMP and my USERS datafile starts at .5 GB and after the IMP is done with ROWS=N (no data), the data...
Hi,
I have created a stored procedure in Oracle 9i and then created a job which should be executed every three minutes (approximately).
declare
v_job number;
begin
dbms_job.submi...
Hi All,
I have a file like this
F|r_country.1|20070616-02:04:43
H|20070616-02:04:43|r_country|1|ISOCNTRYCD|ISOCNTRYDESC
I|CHE|Switzerland
I|DEU|Germany
I|VEN|Venezuela
I|CZE|Czech Repub...
Hi all,
How to actually monitor Oracle tablespaces? Could anyone explain or point me at some useful links, which answers the following,
1. How to diagnose the actual free space ...
I have a problem of extracting time values from a date column.
I have no issues with year, month and a day though.
Sample: '6/20/2006 8:44:03 AM'
The TOAD error is:
ORA-30076: inv...
I am trying to pass 3 unix variabls to a plsql script but I am getting errors. these are the errors that are generated when I run the script. My procedure header is below also.
BEGIN s...
How can I restore the Orcale database from *.dbf files of Oracle. Other important files like redo log file and ctf file are missing. Give me the complete steps if any.
Hi Experts,
I am unable to start the Oracle 9i agent. I am not sure if it's because the server name has been changed. How can I find out the cause and remedy this problem?
Hi friends
i create a role TOAD, grants de privileges only for SELECT and connect, create a user, grant the role to new user, create a synonym and if i login with that user i can...
I have a table "Payments" with the following columns
id_payment amount id_type_payment id_project
1 40 1 8
2 ...
Hi,
I'm trying to load the data of 80000 records into the IVR_REPORT table,
am getting the following error. Database version is Oracle Release 9.2.0.4.0 - Production.
Somebody please help ...
Firefox crashes when trying to use Oracle application after installing JInitiator with a vista computer
Hai !
I have a table named (report_log) on production box under schema (amen). I have the same schema name on development box.
The task is to export the report_log table from p...
I have a package and I would like to run it twice a day in the oracle database .
How would I schedule it ?
thanks,GYANS.
How can I speed up deleting records from my Oracle db?
Currently I have multiple levels of FK constraints with cascade on delete, so when I delete the one record from the main parent table,...
Experts, I have a newbie Question regarding ROWID
I am new to Oracle and I am picking up where someone left off and this person isn't here to ask any questions. I have this query that takes...
