Please take a look at my notes below:
DataPump: Schema/DB Migration Notes
Please take a look at my notes below:
You might be thinking, why is it necessary to specify schemas versus perform full import or why create SQL file?
$ cat impdp_full02_user.par
directory=DATA_PUMP_DIR userid="/ as sysdba" metrics=Y dumpfile=full.dmp logfile=impdp_full_user.log schemas=GGS_ADMIN,DEMO include=USER sqlfile=user.sql
There are 5 users imported which correspond to EXU8USR view.
If users already exists in the new database, wouldn’t create user just fail?
From demo below #schemas=GGS_ADMIN,DEMO (commented) which will
$ impdp parfile=impdp_full02_user.par
Import: Release 11. (more...)
This is still all WIP and if you stay with me, I will provide all the sequences for export and import.
Too much info put in one post.
EXP-10 Usernames Which Cannot Be Exported (Doc ID 217135.1)
Did you know from $ORACLE_HOME/rdbms/admin/catexp.sql there is view EXU8USR providing which schemas will not be in full export?
This looks rather similar to column oracle_maintained from dba_users for 12c database.
Schema bold red will not be (more...)
Oracle Service Bus provides a reporting activity called Alert. The OSB pipeline alerts use a persistent store. This store is file based. Changing the persistent store to JDBC based, does not cause pipeline alerts to be stored in a database instead of on disk. When the persistent store on disk becomes large, opening pipeline alerts in the Enterprise Manager (12c) or Service Bus console (11g) can suffer from poor performance. If you put an archive (more...)
Virtual Development Server: Provide Docker images in docker registry for Oracle XE Database and others
For later creation of containers as needed in the deployment process we have first to build docker images whenever we do not find suitable one in docker hub.
For most of my development I need a oracle database. On the internet you can find a lot of Dockerfile’s for this, but no ready image. This is because for running a database you have to accept a license and this happens when you download the installation (more...)
For those who have been using the Application Integration Architecture on top of Oracle SOA Suite, will probably know that Oracle have sunset AIA as of 12c. For 12.1 there are Core Extensions to help transition onto the 12c platform but 12.2 leaves these behind.
Why you might want to think twice about using INSERT ALL.
One of those things I knew and then forgot.
So, let’s say you’ve got three tables or a partitioned table or something like that.
Let’s use regional tables for simplicity.
drop table t1_r1; drop table t1_r2; drop table t1_r3; create table t1_r1 (col1 varchar2(2) not null ,col2 number not null ,check( col1 in ('R1'))); create table t1_r2 (col1 varchar2(2) not null ,col2 number not (more...)
iAdvise presented the APEX 5.0 roadshows in the first half of 2015. Besides the presentation about the new features, we provided 3 tutorials which helped the visitors to explore Oracle Application Express 5.0. Now we offer these tutorials through our blog. In this article the second tutorial is presented.
A rather not so great post about an ORA-00600 error i faced on a standby database. Environement was 126.96.36.199 on Sun Super Cluster machine. MRP process was hitting ORA-00600 while trying to apply a specific archive log.
The error message was something like this
MRP0: Background Media Recovery terminated with error 600 Errors in file /u01/app/oracle/product/188.8.131.52/diag/diag/rdbms/xxxprd/xxxprd1/trace/xxxprd1_pr00_6342.trc: ORA-00600: internal error code, arguments: , , , , , , , (more...)
Here's the original code:
l_xml := apex_web_service.make_request(...);
-- little hack to remove bad empty namespace from result
l_clob := l_xml.getClobVal();
Permission issues is one of the key error , while setting up Hadoop Cluster, while debugging some error found below table on http://hadoop.apache.org/ . It’s a good scorecard to keep handy.
The following table lists various paths on HDFS and local filesystems (on all nodes) and recommended permissions:
There are couple of my “gotchas”
To quickly re-set the table, my organization purchased the Oracle ZFS Storage Appliance (ZFSSA) 7420. Oracle sold us on the Infiniband connectivity as a way to make a possible future transition to Exadata easier. However the pre-sales (more...)
I just uploaded my DOAG 2013 presentation “Best of Oracle Security 2013“.
This presentation shows how to bypass Oracle Data Redaction, become DBA using CREATE ANY INDEX, Hide information from Oracle Auding using VPD and more…
SQL> select * from scott.credit_card where 1=ordsys.ord_dicom.getmappingxpath((card_id),user,user);
At Derbycon 3.0, László Tóth and Ferenc Spala gave a a new presentation “What’s common in Oracle and Samsung? They tried to think differently… ” (Video). The main focus of the presentation was the Samsung encryption and a new framework called sandy but there was also a small (more...)
The new BI Mobile HD app, version 184.108.40.206.0.2094, can be downloaded from (more...)