I had an interesting AskTom question recently where the poster was using SQL Loader to load in tables, but wanted to be able to analyze the resultant log file after execution. And of course, what better way to analyze..well…anything…than with a database and some SQL.
So we need to be able to access the log file as a table, and an external table is perfect for that, so let’s start there.
Here’s a sample SQL Loader log file (with a little perturbation to preserve anonymity). It’s quite complex because multiple tables were loaded as part of a single SQL Loader run.
Table SCOTT.T1: 222455 Rows successfully loaded. 0 Rows not loaded due to data errors. 1229074 Rows not loaded because all WHEN clauses were failed. 0 Rows not loaded because all fields were null. Table SCOTT.T2: 202547 Rows successfully loaded. 0 Rows not loaded due to data errors. 1248982 Rows…
View original post 1,322 more words
via Finding the trace files
via Wie Ansible bei der Installation einer Big-Data-Distribution helfen kann? – Vorbereitungstasks einer Cloudera Installation
For a few months, I have been working on massive migrations of Oracle 10g/11g databases on Solaris to 12c on Linux. Most of these databases are highly consolidated with several schemas (no PDBs of course), and these schemas are used by different applications. These applications have supposedly nothing do to with each other. Of course, those applications being different, they follow different roadmaps. Knowing this, it was quite impossible to migrate the whole database at once, and schema-by-schema migration was relevant and comfortable for everybody.
I realized that the main challenge to address was not technical complexity, it was more about understanding the muddle between schemas that should be distinct.
Everytime I had to migrate another schema, I wondered : Is this particular schema “self-contained” ? Can I move it with Datapump from one database to another “as is”, with minimum work and error handling ?
I knew DBMS_TTS.TRANSPORT_SET_CHECK procedure…
View original post 654 more words
Source: Flashback in a Data Guard Environment but what are the steps
Jaffar's (Mr RAC) Oracle blog: Oracle R Enterprise Server Configuration: Oracle R Enterprise Server Overview Oracle R Enterprise includes several components on the server. Together these components enabl...
tested in 12.2 You can create a lot of constraints ... create table aa (bbb varchar2(10) not null); Table created. alter table aa add (check (bbb is not null) enable validate); Table altered. alter table aa add (check (bbb is not null) enable validate); Table altered. alter table aa add (check (bbb is not null) enable … Continue reading You can create a lot of constraints …
Source: ClamAV from Oracle