DBA Blogs

Compound triggers

Tom Kyte - Thu, 2017-05-04 02:06
HI TOM SIR I AM IN BEGNING STAGE OF ORACLE PLZ EXPLAIN COMPOUND TRIGGERS IN ORACLE WITH SIMPLE EXAMPLES USING EMP TABLE THANKS&REGARDS ---------------
Categories: DBA Blogs

Backup ORA-19806: cannot make duplex backups in recovery area

Tom Kyte - Wed, 2017-05-03 07:46
Hi Tom, I have try to copy the two copies of backup as with default format as: backup as backupset copies 2 database; error :ORA-19806: cannot make duplex backups in recovery area I have check the space in recovery_area, all right. P...
Categories: DBA Blogs

Importing sequences along with table using DBMS_DATAPUMP package.

Tom Kyte - Wed, 2017-05-03 07:46
Hello All I am trying to import sequence along with tables. In the exported file all three tables(T_VISIT,T_SUBVISIT,T_SERVICES) and sequences(PATIENT_INFO_SEQ,PATIENT_SERVICES_REG2_SEQ) are present. For export, I have already used DBMS_DATAPUMP...
Categories: DBA Blogs

Alter Table Exchange Partition fails with > 1000 subpartitions

Tom Kyte - Wed, 2017-05-03 07:46
We have a list-range(number, timestamp) partitioned table called STREAMING_RESULTS. The table stores very high volume streaming data from a telemetry device. Depending on the channel resolution, some partitions have ~ 3000 subpartitions. I can exchan...
Categories: DBA Blogs

Challenges in pl/sql

Tom Kyte - Wed, 2017-05-03 07:46
What is the challenge you faced as pl/sql developer?
Categories: DBA Blogs

SQL Code Analyzer and CI

Tom Kyte - Wed, 2017-05-03 07:46
Hello AskTom team, could you please suggest any SQL code analyzer/ CI framework or tool for Oracle similar to the following. https://www.slideshare.net/markginnebaugh/microsoft-sql-server-continuous-integration Thanks!
Categories: DBA Blogs

Column usage statistic

Tom Kyte - Wed, 2017-05-03 07:46
Hi I know the usage Statistic based on DML also on DBMS_STATS . REPORT_COL_USAGE. But i mean usage statistic based on select column from table queries. Without Join predicat or smth. like that. I heared about the heatmap. But it is based on an ...
Categories: DBA Blogs

Upgrade from non CDB to CDB - Oracle Metadata

Tom Kyte - Wed, 2017-05-03 07:46
I have two scenarios for upgrade. I have 12cR1 non CDB and 11g database . What is the best way to upgrade these dbs into 2 pdbs in one 12c R2 CDB ( Same OS). If I do a full import from a non CDB into a pdb , will not import all the extraneo...
Categories: DBA Blogs

Unexpected results with NUMBER(32,16) datatype

Tom Kyte - Wed, 2017-05-03 07:46
Hi Number(32,16) datatype columns are behaving differently, When we update those columns, oracle automatically rounding the values to something else. For eg. when we try to update the existing value from 1.0690000000000000 to 1.0690000000001234...
Categories: DBA Blogs

How to calculate current DB size

Tom Kyte - Tue, 2017-05-02 13:26
We requested oracle apex work space area 100MB?It exceeds the over 90% size? How to calculate Current file Utilization and current database size? Requested Size: 100(in MB) Current File Utilization: 6.49(in MB) What is this? Curr...
Categories: DBA Blogs

Peculiar syntax error with analytic functions and division operator. Same error does not occur with multiplication operator

Tom Kyte - Tue, 2017-05-02 13:26
<code> CREATE TABLE lhtest1( C1 varchar(10 char), C2 varchar(10 char), C3 varchar(10 char), C4 varchar(10 char), C5 varchar(10 char), C6 varchar(10 char), C7 varchar(10 char), C8 varchar(10 char), C9 varchar(10 char), C10 varchar(10 char)...
Categories: DBA Blogs

How to find out if the date is a weekend or weekdays

Tom Kyte - Tue, 2017-05-02 13:26
Hi all, I'm having trouble figuring out how to find out if the date is a weekday or a weekend from a column. Scenario CREATE TABLE A (a_id VARCHAR2(20), date_a DATE DEFAULT SYSDATE, CONSTRAINT A_PK PRIMARY KEY (a_id)); TABLE A have...
Categories: DBA Blogs

how to count active login hours with minutes of a employee

Tom Kyte - Tue, 2017-05-02 13:26
how to count login hours with minutes of a employee my scenario is if a employee login at time 'x' and he continue his work up to a certain time period 'y'. my question is how to calculate the active login hours of a employee from time 'x' to ...
Categories: DBA Blogs

Nonblocking mode for the oci connection

Tom Kyte - Tue, 2017-05-02 13:26
Hi Tom! I can create a nonblocking OCI connection and get OCI_STILL_EXECUTING status with ORA-03123 (Operation would block) error, but what is the way to determine which operation would block - reading or writing. I want to handle many Oracle con...
Categories: DBA Blogs

Want to remove special characters from this ِِAA07E01A. Need to get result as AA07E01A

Tom Kyte - Tue, 2017-05-02 13:26
I want a query which will remove special characters from this word: ??AA07E01A. I need a result back as AA07E01A.
Categories: DBA Blogs

Oracle Database 12.2.0.1 – Application PDB unable to sync – An update

Oracle in Action - Tue, 2017-05-02 04:57

RSS content

In my last post, I had demonstrated that without OMF, If an  application creates new datafiles, application PDB’s always fails to sync with the  application.  When I mentioned it to Tim, he raised an SR with Oracle who have clarified that it is  Bug 21933632. Although  it is not documented yet but OMF is mandatory if using the Application Container feature. If it is attempted to sync application PDB’s  with an  application that creates   non-OMF datafile(s),   sync  will run into  problem while trying to replay a create tablespace or similar statement with a hard-coded file name.”

References:

Multitenant: Application Containers in Oracle Database 12c Release 2

————————————————————————————————————————-

Related Links:

Home

Oracle 12c Index

Oracle Database 12.2.0.1 – Application PDB unable to sync



Tags:  

Del.icio.us
Digg

Copyright © ORACLE IN ACTION [Oracle Database 12.2.0.1 – Application PDB unable to sync - An update], All Right Reserved. 2017.

The post Oracle Database 12.2.0.1 – Application PDB unable to sync – An update appeared first on ORACLE IN ACTION.

Categories: DBA Blogs

Creating an ACFS filesystem

DBA Scripts and Articles - Mon, 2017-05-01 15:12

About ACFS filesystem ACFS mean  Automatic Storage Management Cluster File System. This filesystem volume resides inside the ASM database and can be used to store database files but also any type of files with or without direct relation to the database. Oracle ACFS does not support Oracle Grid Infrastructure or Oracle Cluster Registry voting files. … Continue reading Creating an ACFS filesystem

The post Creating an ACFS filesystem appeared first on Oracle DBA Scripts and Articles (Montreal).

Categories: DBA Blogs

Real-time materialized view not working as expected

Tom Kyte - Mon, 2017-05-01 01:06
Hello, I have a problem with <b>Real-time Materialized View `ON QUERY COMPUTATION?</b> functionality. My Real-time MV is enabled for both <b>QUERY REWRITE & ON QUERY COMPUTATION</b>. As I understand, when the MV is fresh, we get a MAT_VIEW R...
Categories: DBA Blogs

Trigger

Tom Kyte - Mon, 2017-05-01 01:06
Hi Team, I have to create one trigger. Whenever some insert happens I want that trigger to be fired. Please see this query: select dept_id, acct_airing_id, lag(dept_airing_id) over (partition by acct_airing_id order by dept_id) as old_dept_a...
Categories: DBA Blogs

Online partitioning and purging old data

Tom Kyte - Mon, 2017-05-01 01:06
Hi Tom, I am writing to you for the first time and I hope you could help me.I should consider resizing of some tables.I am talking about log tables(user event log, app event log, transaction log etc.).They are mostly standalone tables with no childr...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs