Oil Life Drop Goes Up Stop Selecting Data
Feb 7, 2007
Vehicle 1 Odometer OilLife Drop
18454 85.9% < 1st Oil Change keep
20000 35.9% keep
22781 21.5% keep
25911 89.4% < discard 2nd Oil Change keep
28598 74.1% < discard from data
32365 65.1% < discard from data
46000 45.4% < discard from data
49343 94.4% < discard 3rd Oil Change
Vehile 2 Odometer OilLife..
This shows a drop in oil life. I only want up until the FIRST Oil Change happened. So when the Oil Life drop goes up stop selecting data.
View 1 Replies
ADVERTISEMENT
Aug 30, 2012
My oracle version is 11.2.0.2 RAC RDBMS on RHEL 5.6.
At my standby site my physical standby database is on 4 node cluster with all 4 instances up. I need to disable 3,4 instances so that we want it to run on only 1,2 instances.To disable the instances do i need to stop apply(mrp) process. And the apply node is node 1.
View 9 Replies
View Related
Nov 9, 2012
I'd like to stop Recovery in specific time. For instance ; My db works Day-1 and Every day Recovery starts 20:00 and finish 05:00. If it is possible that when DB time reach to sync 03:00, I'd like to stop recovery.
DB version Oracle 10.2.0.5 .....
View 5 Replies
View Related
Mar 29, 2012
i want to stop log shipping to standby database. the whole configuration was done by someone else and now i have been ask to stop it. it is done on test bases and now want to stop it.what i have got from internet is as follows:
Alter system set log_archive_dest_2='DEFER';
and i have got the fol error
ORA-32107:failure in updating spfile
ORA-16179:Incremental changes to "Log_archive_dest_2" not allowed
View 1 Replies
View Related
Jun 18, 2013
I want to select data inserted in the table for that day only.
Table name -->ADJCOLUMNS
i want to select areAccount_no-->number datatype TRANSACT_DATE-- NOT NULL DATE I have written the query below .Is the below query correct.
select account_no,to_char(TRANSACT_DATE,'DD-MON-YYYY HH24:MI:SS') T_date from adj
where to_char(TRANSACT_DATE,'DD-MON-YYYY HH24:MI:SS') between
to_char(TRUNC(sysdate),'DD-MON-YY hh24:mi:ss') AND
to_char(TRUNC(sysdate+1) - 1/86400,'DD-MON-YY hh24:mi:ss');
View 4 Replies
View Related
Feb 17, 2010
How Can We Stop to insert Data if Master Block have the record and detail block have no record but commit command applied i want that commit command can not be work if detail block have no record
View 7 Replies
View Related
Jul 15, 2013
I have table TEST_REP with below data
DA SUMA
---------------------- ----------------------
2011 2
2011 3
2011 5
2012 2
2012 7
2014 2
2014 10
2015 2
2016 33
2015 26
2017 21
2017 2
2018 23
13 rows selected
I have used following query to get the below output:
select
br_mat MAT_YEAR,
sum(br_par) TOTAL
from (
(select to_char(da) br_mat,suma br_par from test_rep)
UNION ALL
[code].......
Output :
MAT_YEAR TOTAL
---------------------------------------- ----------------------
2011 10
2012 9
2013 0
2014 12
2015 28
2016 33
2017 23
2018 23
2019 0
2020 0
10 rows selected
Expected Output :
MAT_YEAR TOTAL
---------------------------------------- ----------------------
2011 10
2012 9
2013 0
2014 12
2015 28
2016 33
2017 and Greater 46
View 6 Replies
View Related
May 27, 2011
I am new to oracle and have an issue with selecting data from a table on date criteria.
select * from table1 t where t.DT BETWEEN TO_DATE(sysdate-1,'dd/mm/yyyy') AND sysdate
my understanding is that this should give me the data for just one day. but it is not.
What I want is, data for last 30days from today.
View 2 Replies
View Related
Sep 7, 2013
I'm facing ORA-28500 error while configuring HSODBC to SQL Server.
Below is the complete information related to listener.ora, sqlnet.ora and tnsnames.ora files. Listener status is showing dg4msql instance successfully started.
I guess I'm facing some issue while creating DB link.
In Oracle 11g Release 11.2.0.1.0 we need to create DB link as below
CREATE DATABASE LINK "DBLNK_ETM_PRODUCTION"
CONNECT TO "USER_NAME" IDENTIFIED BY VALUES 'Password'
USING 'ServerIPAddress:PortNumber/SID';
How to create DB link to SQL Server.
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
"CORE11.2.0.1.0Production"
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
---------------------------------------------------------------------------------------------------------------------
$ cat sqlnet.ora
# sqlnet.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
[Code]...
CREATE PUBLIC DATABASE LINK DBLNK_1 CONNECT TO "manoj" IDENTIFIED BY "mypassword" USING 'SQLDB' ;
SELECT * FROM MyTable@DBLNK_1 ;
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver][libssclient24]General network error. Check your network documentation.
{08001,NativeErr = 11}[Oracle][ODBC SQL Server Driver][libssclient24]ConnectionOpen (Name or service not known()).
{01000}[Oracle][ODBC SQL Server Driver]Invalid connection string attribute {01S00}
ORA-02063: preceding 2 lines from DBLNK_AVL_CLUSTER2
28500. 00000 - "connection from ORACLE to a non-Oracle system returned this message:"
*Cause: The cause is explained in the forwarded message.
*Action: See the non-Oracle system's documentation of the forwarded
message.
Error at Line: 5 Column: 20
View 21 Replies
View Related
Feb 6, 2012
I have to write a proc to display data based on user input for t_grp, and it should exclude grp0
So below is the proc I have written, and I want to display the report for all t_grp when user gives user_input as All or gives null. How can I acheieve this is in procedure.
table: target_data
create table target_data
(
t_mon varcahr2(6)
, t_grp varchar2(30)
, t_data varchar2(50)
)
;
INSERT INTO target_data VALUES ('Apr-11', 'grp1', 'some_data');
INSERT INTO target_data VALUES ('Apr-11', 'grp2', 'some_data');
INSERT INTO target_data VALUES ('Apr-11', 'grp4', 'some_data');
[code]......
Now the above proc is running fine, if I give the input as grp1 or any other t_grp.
View 2 Replies
View Related
Dec 8, 2009
I would like to increase the size of my redo logs. For this I need to drop & recreate them. I have read the Oracle doc [URL] which covers this however :
I have both "normal" and "standby" redo logs (see below) on my primary database - can I drop the standby redo logs? Do these have a link to the redo logs on the standby database?
SQL> SELECt * from v$logfile order by 1;
GROUP# STATUS TYPE MEMBER
---------- ------- ------- ------------------------------------- 1 ONLINE D:ORACLEORADATAREDO01.LOG
2 ONLINE D:ORACLEORADATAREDO02.LOG
3 ONLINE D:ORACLEORADATAREDO03.LOG
4 STANDBY D:ORACLEORADATASTDBYREDO04.LOG
5 STANDBY D:ORACLEORADATASTDBYREDO05.LOG
6 STANDBY D:ORACLEORADATASTDBYREDO06.LOG
View 4 Replies
View Related
Sep 7, 2012
Oracle RDBMS 11.2.0.2 on RHEL 5.6.
I need to drop standby database completeley and rebuilt physical standby for the same database. We identified there are lot of inconsistencies between primary and standby. How do i need to remove the standby? And what is the best procedure?
View 2 Replies
View Related
Jul 26, 2011
shall we stop inserting data into a table before it inserting using Trigger?
View 3 Replies
View Related
Jun 1, 2011
There is one maintenance job owned by SYSMAN running continuously. I want to stop that scheduler job .How ?
IS this the correct syntax to stop the running job ?
exec dbms_scheduler.stop_job(job_name=>'jobname');
View 1 Replies
View Related
Jul 3, 2010
i want check some data from one process instead of last record
i.e
process data
uuu 1
2
3
4
ppp 1
2
3
4
[code].....
View 2 Replies
View Related
Jan 31, 2012
how to stop going to next record if it finds the last record. Because when i click my next button(it is the last record), i try to click my previous or first button but it won't go back, enter-query mode is the error message.
View 9 Replies
View Related
Apr 1, 2012
HOW TO STOP THE UPDATE IN PK COLUMN?
View 3 Replies
View Related
May 25, 2011
SQLserver in stop condition when i play it. it again stop
View 1 Replies
View Related
Apr 9, 2012
I'm trying to install additional Oracle products on my XP VM, but it is telling me to kill all running oracle products. It states that by running the Oracle utility: oradim80 or the Windows NT service Control Panel I can stop all of these services, but I cannot find either.
View 2 Replies
View Related
Nov 3, 2010
I have a form with multiple data block. When i want to query and go to next record then this displayed a message "Do you want save changes". But i would like to stop this message(i.e would not see the message) is it possible.
View 3 Replies
View Related
Feb 7, 2010
I have master detail datablocks. Master block is course and detail block is trainee. students can schedule their courses in a location at particular time.
lets assume student1 has scheduled course A1 in location LA1 from 9am to 12 pm. Now second student shouldn't be able to schedule same course at same time in same location. He can schedule at different time duration. or else same time duration but different location. Or same time, same location but different course.
so, what i did is, i wrote code in when-validate-record of trainee block to display a message saying " cannot schedule course.choose another time." if he try to insert same time duration or same location .
when i am trying to insert a record with time which is already scheduled and in same location, it displays the message but it is also saving the record. i don't want to save the record.
how should i do this? i tried to give ROLLBACK in this trigger but it doesn't accept. i tried pre-insert trigger also but it is also displaying message but saving the record
my code in when-validate-record is:
declare
cursor c1 is
select start_time,end_time,loc
from trainee
where cname=:course.cname;
[code].......
View 5 Replies
View Related
Aug 27, 2013
We are runing (Version: Application Express 4.1.1.00.23)I need to reboot the server.How do I stop APEX gracefully and start it back after?
View 8 Replies
View Related
Jun 2, 2010
I am trying to create a trigger to stop events from being deleted if the date is before the current date. This is the SQL syntax for my table
CREATE TABLE event
(event_id numeric(5) not null,
concert_id numeric(5) not null,
event_date date,
);
What I have attempted so far is:
CREATE OR REPLACE TRIGGER event_deleting
BEFORE DELETE ON event
FOR EACH ROW
BEGIN
IF DELETING THEN
[code]......
This gives me a few warnings, the first is that a DECLARE is missing and the second is a INTO is missing.
View 1 Replies
View Related
Nov 13, 2011
How to stop all jobs(dbms_scheduler) when ever database down or power failure and I need to restart all jobs when ever database is up.
View 3 Replies
View Related
Jul 21, 2011
srvctl stop database d devdb1
After that i got this below status .how to make it up Steup by steup procedure
crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.devdb.db application ONLINE ONLINE islr...v345
ora....b1.inst application ONLINE ONLINE islr...v333
ora....b2.inst application ONLINE ONLINE islr...v345
ora....dbap.cs application OFFLINE OFFLINE
[code]...
View 2 Replies
View Related
Feb 5, 2011
I have master detail block just consider Forms A as a master and Forms B as a Detail,when my cursor is in form A i try to save the record, it is saved Form A and putting Form B data as null, i have to put a validation to stop this activity, i have to inform the user "Provide values for form B text item",
I created a post block trigger in form A
Begin
If (:FORM-B.TEXT1 is null)l or( :FORM-B.TEXT2 is null)
then
Message( 'provide value for FORM-B');
Message( 'provide value for FORM-B');
raise form_trigger_failure;
ELSE
NULL;
END IF
END;
Im Getting error message and navigation got stopped in last item of form A itself,i need to show error message and cursor control should move to first item of form -B which trigger i have to use for this.
View 1 Replies
View Related
Apr 20, 2013
What is the hierarchy to stop and start oracle RAC instance ?
View 10 Replies
View Related
Jan 20, 2012
I need to add some kind of tracing in oracle 11g on linux when oracle starts and stops - as at times oracle takes a long time to start.
View 9 Replies
View Related
Oct 21, 2010
I'm uploading data from excel to our database using forms thru webutil. The problem is when I open the same excel file while the upload process is in progress, the uploading stops, BUT not displaying any error. Not even when I chick Help->Show error.
How could I prevent this error and how to trap and display error message?
View 8 Replies
View Related
Jan 7, 2013
I copied a sqlplus scheduled job procedure. Procedure successfully created .I fount it here [How to Schedule RMAN Daily Backup? [URL]
The procedure is successfully created. Now, doing the following operations:
1) running that job
2) checking whether that job is running or not
3) listing all other jobs
4) unschedule a scheduled job
5) delete a job
6) edit a job
View 3 Replies
View Related
