Tag Info

Hot answers tagged

3

Yes, it is possible. https://docs.oracle.com/database/121/NTDBI/intro.htm#NTDBI2648 Oracle Database supports multiple Oracle homes. You can install this release or previous releases of the software more than once on the same system, in different Oracle home directories. This allows flexibility in deployment and maintenance of the database ...


3

After a pretty good amount of digging, I found this blog post on doing this for date ranges, and it turns out to work equally well on numeric ranges, with a little modification for handling the 0 and 1 endpoints. Taking the query from there and renaming the columns to be a bit more clear, we have SELECT * FROM (SELECT MAX(T_END) OVER (ORDER BY T_START) ...


2

You are facing a bug. You need to gather more information using RDA in order to perform an in-depth analysis. These are known bugs related to your ORA-600 message. 10043021 11.2.0.4, 12.1.0.1 ORA-600 [kcbnew_3] after select / analyze on RECYCLEBIN object 17586955 11.2.0.4.4, 11.2.0.4.BP11 ORA-600 [ktspfmdb:objdchk_kcbnew_3] in RAC 12747437 ...


2

Proper backup syntax should have been: backup database tag "first" plus archivelog tag "first"; Now if you look into your list backup output you can notice that only backupsets with archivelogs has tag FIRST. Backupset containing backup of datafiles has autogenerated tag TAG20150515T105436.


2

Output is from a 11.2.0.4.6 Enterprise Edition database on Oracle Linux 7.1 x86-64 platform. Lets start with question 2 and an easy example. DISTINCT and GROUP BY are handled differently: the optimizer is able to completely eliminate a DISTINCT under certain circumstances, but it can not do the same with GROUP BY. Here is an example: create table t4 as ...


1

The solution is really dependant on your environment. There are numerous options, from hardware firewalls, to software firewalls, to sqlnet.ora parameters. The first two are beyond the scope of this site. The quickest, probably, is sqlnet.ora. Have a look at the tcp.invited_nodes parameter: ...


1

Not supported. If you want to send e-mails (JavaMail?) from the database, you do not need Java in the database for that, just use the UTL_MAIL package, available in XE as well.


1

No way how to do that. XE version does not support Java Stored Procedures. You have to upgrade at least to "Standard Edition One" or "Oracle Personal Edition". See edition comparsion.


1

I think select 1 from dual; is a syntax error. Here's what happens on the wire: With select 1 from dual a connection's lifecycle is: Initial establishment First query (validation does not yet happen) Return to the pool Validation: the pool sends select 1 from dual The database answers: ORA-01403: no data found Next query and so on. The connection is ...


1

https://support.oracle.com, with a valid support contract. In most cases, even there you will not find the meaning of the arguments. Of course, with access to the source code (e.g Oracle Support employees), one can find the meaning of these arguments, as demonstrated in the Oracle DSI401e course, with a case study.


1

i've found the definitive answer from the oracle docs http://docs.oracle.com/cd/E11882_01/license.112/e47877/editions.htm#DBLIC109 in the Oracle Database Standard Edition and Oracle Real Application Clusters (Oracle RAC) section, it specifies "Oracle Automatic Storage Management is required for creating and managing all Oracle database file types. Raw ...



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