Hot answers tagged

7

For single node Oracle RDBMS installations, an SCN is never duplicated. With older versions of Oracle RAC, Oracle 9i for example, it was possible that two transactions, running on separate RAC nodes, could end up with the same SCN. Duplicates happened only in rare situations where high transaction rates on the RAC nodes was coupled with a large value for ...


2

There should not be any problems. Nobody should use this password for application purposes. In case of RAC cluster do not forget to change the password on each node. This password is not stored in the database but in local node's password file. Unless you use Oracle Data Guard (physical replication). For some reason having the same password on each side is ...


2

I'm sure this has already been asked before, but .. from the Oracle documentation Further down the page, when you look for what each constraint state is: VALIDATE | NOVALIDATE The behavior of VALIDATE and NOVALIDATE always depends on whether the constraint is enabled or disabled, either explicitly or by default. Therefore they are described in the ...


1

It only allows access to data dictionary views, so the only security implication is that the users(s) would be able to see which objects existed in the other schemas. They would not, however, be able to actually view the data in the other schemas. I said there was only one security implication, but another is that they would be able to view the source of ...


1

First of all, people often fall for this, but high log file sync waits do not necessarily mean I/O problem. Second, this could be really troublesome, if you have many physical devices in the ASM diskgroup where your redo logs are, because the extents of your files will be evenly distributed on several disks. Anyway, you need to find the ASM diskgroup ...


1

Make your where clause operate conditionally based on your input value like this: SELECT URYRR_FORWARDS_REC_H.CB_LINE as "CB_LINE", URYRR_FORWARDS_REC_H.CB_LINE_DESCRIPTION as "DESCRIPCION", URYRR_FORWARDS_REC_H.UYU_BALANCE_FW as "MONEDA LOCAL", URYRR_FORWARDS_REC_H.USD_BALANCE_FW as "MONEDA EXTRANJERA", URYRR_FORWARDS_REC_H.UYU_BALANCE_COA as "MONEDA LOCAL"...


1

You could do both a union of the tables and an intersection of the tables and then get the difference between these. create table table1 as (select 1 id, 'Aron' name, 23 age from dual); insert into table1 values (2,'Bary',30); create table table2 as (select 1 id, 'Aron' name, 21 age from dual); insert into table2 values (2,'Bary',30); ( select * from ...



Only top voted, non community-wiki answers of a minimum length are eligible