This is how I dump data from an Oracle Database (tested on 8i,9i,10g,11g,12c) to a delimited ascii file:
SQL*Plus: Release 188.8.131.52.0 Production on Fri Feb 24 13:55:47 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Oracle Database 12c Standard Edition Release 184.108.40.206.0 - 64bit Production
SQL> set timing on
SQL> select Dump_Delimited('select * from all_objects', 'all_objects.csv') nr_rows from dual;
In February, March and April we offer free on-demand
Bootcamps for SOA Suite 12c and BPM Suite 12c. For details and
registration please visit the training calendar:
Are you getting the ORA-06550 error when running an SQL statement? Learn the cause of this error and the solution in this article. Demonstration of the Error To demonstrate this error, I can run this code: CREATE OR REPLACE PROCEDURE testProcedure AS textValue VARCHAR2(3); BEGIN textValue := someOtherValue; END; If I compile this […]
Senior EBS Development staff (including me) are presenting at the Higher Education User Group (HEUG) Alliance 2017 conference in Las Vegas from February 27 to March 2. This is your opportunity to get the latest updates on our E-Business Suite roadmap. Check out the Alliance session catalog for a complete list of all Oracle EBS Development sessions:
We are also hosting a Meet The Experts roundtable where you can (more...)
If you have an Interactive Report with the Subscription feature enabled, users can “subscribe” to the report, getting a daily email with the results of the report. Unfortunately, however, this feature doesn’t work as expected if it relies on session state – e.g. if the query uses bind variables based on page items to filter the records. In this case, the subscription will run the query with a default session state – Apex doesn’t (more...)
Oracle dbms_datapump provides a parallel option for exports and imports, but some objects cannot be processed in this mode. In a migration project from AIX 11gR2 to ODA X5-2 ( OL 5.9 ) 12c that included an initial load for Golden Gate, I had to deal with one of those objects, a 600G table with LOB fields, stored in the database as Basic Files ( = traditional LOB storage ).
By applying some DIY (more...)
Recently i had to reimage a couple of Exadata compute nodes for different reasons like an almost simultaneous failure of 2 harddisks in the compute node.
After the compute got back online with a fresh image and restoring settings like cellip.ora, DNS, NTP and cellinit.ora we got to the point where we need to reinstall the Oracle components, this clusters has an 220.127.116.11 Grid Infrastructure, and 18.104.22.168. (more...)
Are you getting the ORA-00933: SQL command not properly ended error? Learn what causes it and how to resolve it in this article. ORA-00933 Cause You have run an SQL statement and have gotten this error: ORA-00933: SQL command not properly ended What causes this error? Most likely, the SQL statement you’re running has a […]
This blog entry shows you how to reset the
system password for an Oracle Database. It uses a Linux image running Oracle Database 11g Express Edition. It assumes the
student user is the sudoer user.
After you sign on to the
student user account, you open a Terminal session and you should see the following:
oracle user account should be configured to prevent a login. So, you should use the
Recently I’ve seen not so smart optimizer behavior: one query took long time to parse, and ended with an error hitting PGA_AGGREGATE_LIMIT in few minutes; another query was just parsed for ages while using reasonable (under 2G :)) amount of PGA and still could hit PGA_AGGREGATE_LIMIT but after way more time – up to an hour.
Both cases were similar and involved queries which were accessing views; and those views’ code is generated by an (more...)
Recently I have had an issue with slow unicode migration of the database upgraded from 10g to 22.214.171.124. The main problem was a table with xmltype: we spent about 4 hours for this table(~17GB) during test migration, though all other tables (~190GB) migrated just for about 20 minutes.
We used DMU(Database Migration Assistant for Unicode), and the root cause of the problem was update statement generated by DMU for this table:
I attended the first Dublin Tech Summit (@DTS) and have to
say I was very impressed by the depth and breadth of the event, and even
learned new things, renewed old acquaintances and forged new business
DTS offered a powerful schedule covering
from Fashion and Healthcare to IoT and FinTech and more for an audience ranging
from storytellers to investors to coders, and was combined with workshops and a
platform for startups as well (more...)
Once you have defined your users for your Express Cloud Service, all users with the role of Database Developer or higher can access the database Service Console. From here all database related actions can be started.
The upper category, Web Access, brings you to the specified part of the APEX builder - more on that in the next post. In the lower category you can create database schema's. For our goal within smart4apex, I created (more...)
Once you get your services up and running, you can log into your domain - in this screenhot "smart4apex" - on the Oracle Cloud.
Then you'll end up in the "My Services" dashboard. As I have only one, my dashboard looks quite clean, showing just this widget:
Just a few remarks for the designers of this: I am very curious why there is an extra "(Number of ..."
in the chart title. The same (more...)
Here’s one of those little improvements in 12c (including 12.1) that will probably end up being described as “little known features” in about 3 years time. Arguably it’s one of those little things that no-one should care about because it’s not the sort of thing you should do on a production system, but that doesn’t mean it won’t be seen in the wild.
Rather than simply state the feature I’m going to demonstrate it, (more...)