Feed aggregator

Real Time Scenarios & duplicate rows

Tom Kyte - 5 hours 22 min ago
I have two questions 1.) Deleting Duplicate rows DELETE FROM EMP1 WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM EMP1 GROUP BY EMPNO); the above command deletes the duplicate rows from a given table such as emp1 in this case, group by eliminat...
Categories: DBA Blogs

Cascading calculated LAG values

Tom Kyte - Thu, 2016-07-28 17:06
Oracle Example SQL to explain my question: https://livesql.oracle.com/apex/livesql/file/content_DMZ4GO3W9QL4BONQQB8I7NP5X.html The SQL I am working on is monthly data based on two categories (CATEGORY_A and CATEGORY_B). While we get valu...
Categories: DBA Blogs

DDL timeout parameter limit

Tom Kyte - Thu, 2016-07-28 17:06
Hi Tom I have read in the below link that DDL will not require any downtime starting from Oracle 11g (understood that same applies to Oracle 12c): http://www.oracle.com/technetwork/database/features/online-ops-087977.html I am using Oracle 12c...
Categories: DBA Blogs

Return first character of each word

Tom Kyte - Thu, 2016-07-28 17:06
Sir can you help me regarding this query in SQL by using character functions only.... I/P : ABC DEF GHI Output: ADG
Categories: DBA Blogs

ORA-00980 translation is no longer valid

Tom Kyte - Thu, 2016-07-28 17:06
Dear Sir, I am exporting a database from one system and importing it in another system. after importing its shows the error ORA-00980 tranlation is no longer valid everywhere i can see the solution but my question is 1)its working well with wit...
Categories: DBA Blogs

Invalid rowid in deadlock trace file...I must be missing something

Tom Kyte - Thu, 2016-07-28 17:06
Hi! We recently had an event where a trigger was changed by only a few lines resulting in hundreds of deadlocks a minute. We changed it back and all is well. I'm trying to figure out what happened though. The change in the trigger was if inserting s...
Categories: DBA Blogs


Tom Kyte - Thu, 2016-07-28 17:06
Hi Sir i am new for oracle. ____Q1) 2. Disabled validate - 3. Enabled novalidate 4. Enabled validate Please explain briefly with primary key constraints only with example (either 3Q or 4Q take any one ) Q2)while doing outer join(left/reght) ...
Categories: DBA Blogs

Code enchancement

Tom Kyte - Thu, 2016-07-28 17:06
Hell Chris, i have tables called t1 and t2. Table T1 Script as follows: <code> DROP TABLE T1 CASCADE CONSTRAINTS; CREATE TABLE T1 ( ID NUMBER ) Insert into T1(ID) Values(2001); Insert into T1(ID) Values(3001); Insert into...
Categories: DBA Blogs


Tom Kyte - Thu, 2016-07-28 17:06
Categories: DBA Blogs

Banishing some PeopleSoft Myths

Duncan Davies - Thu, 2016-07-28 11:05

There seems to be quite a bit of uncertainty and misinformation in the PeopleSoft marketplace currently, so I thought it might be time to banish a few myths:

1. PeopleSoft isn’t being improved/getting investment

There are those with vested interests or other biases that will always deny this regardless of the evidence put in front of them, but PeopleSoft is improving in leaps and bounds. In the last couple of years PeopleSoft has been moving at an increasing speed, and one of the biggest questions on many client’s minds right now is “how do I keep up”. My Cedar colleague Graham Smith has a long list of recent new features in his PeopleSoft Predictions 2016 post, but if you just counted Fluid, Selective Adoption and Cloud Delivery Architecture I don’t think there’s ever been a time in which PeopleSoft has improved so much in a short space of time, pre or post-acquisition. Paco has repeatedly committed to keeping PeopleSoft around until at least 2027, and using the last few years as evidence I’m inclined to believe him.

2. PeopleSoft is Legacy/Old Fashioned

PeopleSoft is certainly very well established, with a long history and a wide customer base, that much is true. This can be a good thing, in that much of the system is tried and tested with the wrinkles ironed out. It is also true that some aspects of PeopleSoft do things the ‘old way’. The majority of deployments are on-premises, without the flexibility and efficiency that cloud deployment and automation can bring. You also pay for PeopleSoft up-front, rather than monthly. It doesn’t have to be this way, however. PeopleSoft can be deployed in an agile and efficient manner, taking advantage of some of the new technology available to us now, and the new enhancements within the product.

3. To be a future-proof system it needs to be SaaS

This is tricky as different people hold varying ideas about what constitutes SaaS, however PeopleSoft does get regular updates containing new functionality from the vendor (every ~10 weeks), can be deployed in the Cloud (to gain auto-scaling/elasticity of resources, a predictable monthly subscription and theoretically even multi-tenancy – at least above the database-level, if it was something that clients wanted). Furthermore, the application of the updates and the management of the cloud architecture can be handed over to a friendly partner in order to get even closer to purists’ definitions of what SaaS entails – if that is important to you.

4. PeopleSoft’s UI is out-dated

Up until a few years ago there wasn’t the focus on ‘consumer grade UI’ that there is now. In that era, PeopleSoft’s UI measured up pretty well. It was certainly more attractive than SAP and/or E-Business Suite. Recently this greater focus on the User Interface has introduced new competitors but PeopleSoft still keeps up well. Of course you can compare an old version of PeopleSoft with the latest from a competitor and it will appear dated in comparison, however if you use the latest PeopleSoft UI in the comparison it’ll fare rather better. The Fluid UI is (at least) the equal of anything out there, regardless of which device you view it on.

5. The PeopleSoft Market is Quiet

From what I can see there are fewer green-field implementations than 5 years ago, but there is a lot more upgrade activity. Clients are moving to 9.2 at a far greater rate than for 9.0 or 9.1, and then starting initiatives to really get value from the software once they get there. As a company I’m not sure Cedar has ever been busier.

So, now I’ve got that off my chest, I might do some predictions like Graham next …

How to manage your containers in Oracle Storage Cloud Service ?

Yann Neuhaus - Thu, 2016-07-28 07:57

Oracle Cloud Storage Service provides secure, scalable and consistent data from any environment.
To get a higher flexibility for your backups, I suggest to use a CloudBerry application in Oracle Public Cloud.

This application can be used on Cloud Backup and Recovery in PaaS and IaaS infrastructures.
We are going to use it for our DbaaS in PaaS infrastructure.
However, a user-friendly third party tool can also be used as CloudBerry Explorer for OpenStack as managing Storage Containers.

Before starting with CloudBerry it is necessary to subscribe to a trial access or to buy a billing frequency hourly or monthly. In both cases, we have the same functionalities.

Let’s go !

Follow all steps to subscribe your free trial access in the PaaS / DbaaS category on https://cloud.oracle.com/home.
Once your account is registered, you will receive an e-mail from Oracle with subscription details.

This e-mail contains a lot of services, but we will only use the Oracle Backup Service. We can notice that our Backup Service has a data region (UK) and a link to associated documentation (same for other services).

Oracle Database Backup Service
Data Region: UK001
Get Started: http://docs.oracle.com/cloud/latest/dbbackup_gs/index.html

In the next steps, we will have a look on different types of Backup Services. The access to the Backup Services is linked to your account.

You need :
Your email address
Your password
Your Identity Domain

Start with CloudBerry by downloading and installing the following link : http://www.cloudberrylab.com and install it.

Step 1 – Creating an Oracle connection

File > New Oracle Account


The account location depends on where you have subscribed your Datacenter. This account is notified when you receive your confirmation e-mail. Note that your storage space is linked with your identity domain and that all services, which depend on your subscription, will be stored in this area.

Once the connection is established we are going to create a container for the backup storage area (process below).


This page shows other containers as well as our “SandBox” container we just created. The “_apaas” belongs to an Application Container Cloud I created as a service on my Oracle Public Cloud.

We will use our SandBox container to create our Oracle Backup Service. There are 2 kinds of containers, “Standard & Archive”.

Standard : Containers are similar to a directory structure but with a key distinction: unlike directories, containers cannot be nested.
By default, all containers are of the standard storage class (as opposed to the archive storage class).

Archive : You can use Archive containers to store data that won’t be accessed for a while or that will be accessed infrequently.

For example :


In Cloud, we can monitor storage capacity of your Oracle Database Backup Service.


Step 2 – Connection in your Oracle Public Cloud


Once the connection to your Oracle Public Cloud is established, we shall create a new database with a Backup storage area. I am not going to describe all steps to create a database in a Cloud, but rather some steps to backup the storage and a summary before we create it.

Step 3 – Creating Cloud Database with Backup and Recovery configuration Here is the summary of out DBaaS creation :


As you will notice in the backup destination section, we have chosen a backup location option for the database in your service and, depending on your choice, provided information regarding the Oracle Storage Cloud service container where cloud backups have to be stored.

Backup Destination: we are going to store our backup in a Cloud or/in a local storage.


For configuration, remember your :

Cloud Storage Container : <store service name>-<identity domain name>/<container name>

Step 4 – Backup Tests

First, we shall execute a backup of the database with RMAN command, then we will be able to check the results.


The backup has been correctly performed with RMAN command. So we will see if we have our backup pieces in your container.


 As shown in the picture above, we find the backups in our “SandBox” container.

Step 5 – How to check my backup parameters ?

When you perform a “Show All” command in RMAN you can check how your channel is configured for backups. There you should have a library parameter set up in RMAN as follow :


We can notice that there are “SBT_TAPE” channels for the device with its library (libopc.so) and the configuration which is limited to maxsize of 2 Go.

We see a parameter file called opcSDBX.or which contains the settings to access the backup cloud service Container. Then you can check it and open it with a text editor.


Here we find our parameters entered previously when we created our access in the Oracle Cloud backup. We can observe one important thing: we use a wallet to secure backups and recovery in Cloud.


Easy to use, simple to set up, just try it !


Cet article How to manage your containers in Oracle Storage Cloud Service ? est apparu en premier sur Blog dbi services.

Oracle Buys NetSuite

Oracle Press Releases - Thu, 2016-07-28 06:52
Press Release
Oracle Buys NetSuite

Redwood Shores, Calif.—Jul 28, 2016

Oracle (NYSE: ORCL) today announced that it has entered into a definitive agreement to acquire NetSuite (NYSE: N), the very first cloud company. The transaction is valued at $109.00 per share in cash, or approximately $9.3 billion.

“Oracle and NetSuite cloud applications are complementary, and will coexist in the marketplace forever,” said Mark Hurd, Chief Executive Officer, Oracle. “We intend to invest heavily in both products—engineering and distribution.”

“We expect this acquisition to be immediately accretive to Oracle’s earnings on a non-GAAP basis in the first full fiscal year after closing,” said Safra Catz, Chief Executive Officer, Oracle.

“NetSuite has been working for 18 years to develop a single system for running a business in the cloud,” said Evan Goldberg, Founder, Chief Technology Officer and Chairman, NetSuite. “This combination is a winner for NetSuite’s customers, employees and partners.”

“NetSuite will benefit from Oracle’s global scale and reach to accelerate the availability of our cloud solutions in more industries and more countries,” said Zach Nelson, Chief Executive Officer, NetSuite. “We are excited to join Oracle and accelerate our pace of innovation.”

The evaluation and negotiation of the transaction was led by a Special Committee of Oracle’s Board of Directors consisting solely of independent directors. The Special Committee unanimously approved the transaction on behalf of Oracle and its Board of Directors.

The transaction is expected to close in 2016. The closing of the transaction is subject to receiving certain regulatory approvals and satisfying other closing conditions including NetSuite stockholders tendering a majority of NetSuite’s outstanding shares in the tender offer. In addition, the closing is subject to a condition that a majority of NetSuite’s outstanding shares not owned by executive officers or directors of NetSuite, or persons affiliated with Larry Ellison, his family members and any affiliated entities, be tendered in the tender offer.

More information about this announcement is available at www.oracle.com/netsuite.

Contact Info
Deborah Hellinger
Oracle Corporate Communications
Ken Bond
Oracle Investor Relations
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation.

Cautionary Statement Regarding Forward-Looking Statements

This document contains certain forward-looking statements about Oracle and NetSuite, including statements that involve risks and uncertainties concerning Oracle's proposed acquisition of NetSuite, anticipated customer benefits and general business outlook. When used in this document, the words "anticipates", "can", "will", "look forward to", "expected" and similar expressions and any other statements that are not historical facts are intended to identify those assertions as forward-looking statements. Any such statement may be influenced by a variety of factors, many of which are beyond the control of Oracle or NetSuite, that could cause actual outcomes and results to be materially different from those projected, described, expressed or implied in this document due to a number of risks and uncertainties. Potential risks and uncertainties include, among others, the possibility that the transaction will not close or that the closing may be delayed, the anticipated synergies of the combined companies may not be achieved after closing, the combined operations may not be successfully integrated in a timely manner, if at all, general economic conditions in regions in which either company does business, and the possibility that Oracle or NetSuite may be adversely affected by other economic, business, and/or competitive factors. Accordingly, no assurances can be given that any of the events anticipated by the forward-looking statements will transpire or occur, or if any of them do so, what impact they will have on the results of operations or financial condition of Oracle or NetSuite.

In addition, please refer to the documents that Oracle and NetSuite, respectively, file with the U.S. Securities and Exchange Commission (the "SEC") on Forms 10-K, 10-Q and 8-K. These filings identify and address other important factors that could cause Oracle's and NetSuite's respective operational and other results to differ materially from those contained in the forward-looking statements set forth in this document. You are cautioned to not place undue reliance on forward-looking statements, which speak only as of the date of this document. Neither Oracle nor NetSuite is under any duty to update any of the information in this document.

Oracle is currently reviewing the existing NetSuite product roadmap and will be providing guidance to customers in accordance with Oracle's standard product communication policies. Any resulting features and timing of release of such features as determined by Oracle's review of NetSuite's product roadmap are at the sole discretion of Oracle. All product roadmap information, whether communicated by NetSuite or by Oracle, does not represent a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision. It is intended for information purposes only, and may not be incorporated into any contract.

Additional Information about the Acquisition and Where to Find It
In connection with the proposed acquisition, Oracle will commence a tender offer for the outstanding shares of NetSuite. The tender offer has not yet commenced. This document is for informational purposes only and is neither an offer to purchase nor a solicitation of an offer to sell shares of NetSuite, nor is it a substitute for the tender offer materials that Oracle and its acquisition subsidiary will file with the SEC upon commencement of the tender offer. At the time the tender is commenced, Oracle and its acquisition subsidiary will file tender offer materials on Schedule TO, and NetSuite will file a Solicitation/Recommendation Statement on Schedule 14D-9 with the SEC with respect to the tender offer. The tender offer materials (including an Offer to Purchase, a related Letter of Transmittal and certain other tender offer documents) and the Solicitation/Recommendation Statement will contain important information. Holders of shares of NetSuite are urged to read these documents when they become available because they will contain important information that holders of NetSuite securities should consider before making any decision regarding tendering their securities. The Offer to Purchase, the related Letter of Transmittal and certain other tender offer documents, as well as the Solicitation/Recommendation Statement, will be made available to all holders of shares of NetSuite at no expense to them. The tender offer materials and the Solicitation/Recommendation Statement will be made available for free at the SEC's web site at www.sec.gov.

In addition to the Offer to Purchase, the related Letter of Transmittal and certain other tender offer documents, as well as the Solicitation/Recommendation Statement, Oracle and NetSuite file annual, quarterly and special reports and other information with the SEC. You may read and copy any reports or other information filed by Oracle or NetSuite at the SEC public reference room at 100 F Street, N.E., Washington, D.C. 20549. Please call the Commission at 1-800-SEC-0330 for further information on the public reference room. Oracle's and NetSuite's filings with the SEC are also available to the public from commercial document-retrieval services and at the website maintained by the SEC at http://www.sec.gov. 

Learn More
Talk to a Press Contact

Deborah Hellinger

  • +1.212.508.7935

Ken Bond

  • +1.650.607.0349

Oracle FROM_TZ Function with Examples

Complete IT Professional - Thu, 2016-07-28 06:00
In this article, I’ll explain what the Oracle FROM_TZ function is and show you some examples. Purpose of the Oracle FROM_TZ Function The purpose of the FROM_TZ function is to convert a TIMESTAMP value and a specified TIME ZONE to a TIMESTAMP WITH TIME ZONE value. It seems like a simple data conversion function, but […]
Categories: Development

Exact count of alphabet

Tom Kyte - Wed, 2016-07-27 22:46
Sir, I want the query so that I have the names of person who are having exactly have 2 'a' in his or her name.. M trying query but m getting more then 2 'a'. But i want exactly two. Thanks.
Categories: DBA Blogs

data pump api - keep master

Tom Kyte - Wed, 2016-07-27 22:46
Is there a way to keep the master table on the successful completion of a data pump import/export using the API? There looks to be a way to keep the master table when using interactive data pump (keep_master=Y).
Categories: DBA Blogs

database migration from sun sparc to solaris x86_64

Tom Kyte - Wed, 2016-07-27 22:46
We are planning to migrate our databases from sun sparc machine to solaris x86_64. Both are different endian format. Could you please let me know the best approach to migrate these databases
Categories: DBA Blogs

How to Read and Load Swift Message into Database

Tom Kyte - Wed, 2016-07-27 22:46
Hi Tom, This is regarding SWIFT MESSAGE (MT900 format). On Daily basis ,We will be receiving Bank to Bank transactions details in the form of SWIFT Message (MT900 format) i.e in .txt file. Here , Ask is to Read and LOAD swift message tags ...
Categories: DBA Blogs

deletion of controlfiles

Tom Kyte - Wed, 2016-07-27 22:46
hi Team, even after deleting all the controlfiles the checkpoint doesn't gives me error, where the checkpoint writes the information where no controlfile is available? Kindly clarify.
Categories: DBA Blogs

table join evaluation (ORA-01722: invalid number)

Tom Kyte - Wed, 2016-07-27 22:46
Hello AskTom Team, Could you please explain how optimizer evaluates the join with wrong data types? <code> CREATE TABLE TEST1(COL1 NUMBER,COL2 VARCHAR2(100)); CREATE TABLE TEST2(COL1 NUMBER,COL2 VARCHAR2(100)); CREATE TABLE TEST3(COL1 NUMBER...
Categories: DBA Blogs


Tom Kyte - Wed, 2016-07-27 22:46
Hi ,I installed Oracle 12c on my laptop , and when i try to connect from form builder gets this error ORA-12154 :tns : couldn't resolve the connect identifier specified I tried all ways but not solved I hope anyone can help me cause I only know ab...
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator