DBA Blogs

show a grid of deleted records

Tom Kyte - Sat, 2019-02-23 01:06
Hi Tom, please i need your help ASAP !!! i have a grid of (agents) in oracle apex with the button DELETE , and i want to know the steps how to show deleted rows in another grid
Categories: DBA Blogs

Materialized view log , logminer

Tom Kyte - Fri, 2019-02-22 07:06
Hello Tom, would you explain a little which way is better to check on delta of information to populate DWh on schema? Materialized view log or LOGMNR?
Categories: DBA Blogs

Oracle 12c Performance issue after upgrading database from 10.2.0.5.0 to 12.1.0.2.0

Tom Kyte - Fri, 2019-02-22 07:06
Hello, One of our client has upgraded Test environment Oracle database from 10.2.0.5.0 to 12.1.0.2.0 with Production data. After upgrading the database, we are facing performance issue in few processes which are taking huge time to complete com...
Categories: DBA Blogs

EXP: how to include the "CREATE USER" statement without perform a full export?

Tom Kyte - Fri, 2019-02-22 07:06
Hello. I need to export an oracle schema using exp, included the "CREATE USER" statement. Now, for do that the only think to do that I know is perform a full export of the database. The problem is that in my database there are a lot of users and th...
Categories: DBA Blogs

rman question

Tom Kyte - Fri, 2019-02-22 07:06
thomas, happy holiday. I have question(s) related to rman 1. what is the difference between - to back up the current control file and to backup up control file copy(backup controlfile copy) 2. when using either of above command tag and ...
Categories: DBA Blogs

a sql code to remove all the special characters from a particular column of a table

Tom Kyte - Thu, 2019-02-21 12:46
a sql code to remove all the special characters from a particular column of a table . for example : iNPUT-ABC -D.E.F OUTPUT ABC DEF AND IF THERE IS TWO NAMES LIKE ABC PRIVATE LTD ONE SPACE SHOULD BE MAINTAINED BETWEEN 2 WORDS.
Categories: DBA Blogs

DISTINCT vs UNION

Tom Kyte - Thu, 2019-02-21 12:46
Hello Tom, my test case create table xxx as select * from dba_tables; insert into xxx select * from dba_tables; I tried 2 queries 1* select distinct * from xxx 2359 rows selected. Execution Plan -----------------------------------------...
Categories: DBA Blogs

Please help to understand how Nested Table cardinality estimation works in Oracle 12C

Tom Kyte - Wed, 2019-02-20 18:26
Hi Team, Request your help with one issue that we are facing. We pass a Nested table as a variable to a select statement. Example SQL is: <code>SELECT CAST ( MULTISET ( SELECT DEPTNBR FROM DEPT ...
Categories: DBA Blogs

Presentation of function result, which is own-type table via SELECT <func> FROM DUAL in sql developer.

Tom Kyte - Wed, 2019-02-20 18:26
Hi TOM, I've created a function, that granting access to tables and views in given schema to given user. In result, function returns a own-type table, that contains prepared statement and exception message, if thrown. 1. Creating types: <code...
Categories: DBA Blogs

With clause in distributed transactions

Tom Kyte - Wed, 2019-02-20 18:26
Hi Tom ! As there is put a restriction on GTTs: Distributed transactions are not supported for temporary tables does that mean that inline views in a query, i.e. using WITH clause, but those with MATERIALIZED hint will not work properly...
Categories: DBA Blogs

Partner Webcast – From Mobile & Chatbots to the new Digital Assistant Cloud

In the last few years we have seen a massive growth in the mobile usage of instant messaging and chat applications. With Oracle Intelligent Bots, an integrated feature of Oracle Mobile Cloud...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Oracle Identity Cloud Service enabling legal and compliance requirements

Context of identity and cloud access controls An intelligent Security Operations Center (SOC) needs threat intelligence and contextual awareness but, first of all, it needs to have the context of...

We share our skills to maximize your revenue!
Categories: DBA Blogs

SQL Performance Tuning

Tom Kyte - Wed, 2019-02-20 00:06
Hi Team, i am kinda new to SQL performance tuning, So i need you guys to suggest me some helpful hand books (with test cases) which will suit for me. I have googled for it but don't know which one should i prefer as a newbie. So please share your...
Categories: DBA Blogs

What does argument "shares" stand for in create_plan_directive()?

Tom Kyte - Wed, 2019-02-20 00:06
Hi, In procedures create_cdb_plan_directive() or create_cdb_profile_directive() of dbms_resource_manager package, it is clear what role plays The parameter called "shares". Now, I fail to see what can be done with this parameter in create_plan_dir...
Categories: DBA Blogs

Dynamic database creation

Tom Kyte - Wed, 2019-02-20 00:06
Hello.. I'm asking if there is anyway to create an Oracle PDB database dynamically, I mean after the completion of some web registration, for example if I want to provide a complete private oracle database for my customer after he/she register to ...
Categories: DBA Blogs

How to print function name in sqlplus along with creation time.

Tom Kyte - Wed, 2019-02-20 00:06
Hi, I need advise on below query. Whenever we created any procedure/function from sqlplus command prompt then Function created message shown in sqlplus. E:g SQL> @C:\abc.fnc; Function created. 1:Can...
Categories: DBA Blogs

REGEXP_LIKE - Pattern match with complex logic

Tom Kyte - Tue, 2019-02-19 05:46
I want to do the regexpr pattern matching and I couldn't. Please help. I want to evaluate the value that is going to be inserted in DB. I want to perform a check as below. Only four special characters and alphabets are allowed. other special ch...
Categories: DBA Blogs

The relationship between null and 0

Tom Kyte - Tue, 2019-02-19 05:46
I asked you one last time and I will ask you one more question. If !=0, we know we should include null, but the result is not null. If !=0, it is different from zero and null, should not it also contain null if it is not 0?
Categories: DBA Blogs

Select from a table where a key value has matching link for all key values of another table

Tom Kyte - Tue, 2019-02-19 05:46
I have a set of three tables (T1, T2, T3) that represent dictionary data from external sources. I need to match the data from table 1 with the data in table 3 where <b><i>all</i></b> the rows in table 1 for a given OR_ID are reflected in table 3. T...
Categories: DBA Blogs

Update statement to flag rows

Tom Kyte - Tue, 2019-02-19 05:46
Hello, Ask Tom team. I'm using the query below to load rows to a destination database based on some conditions. After this is done I want to flag those rows in order to exclude them in the next SSIS ETL run. <code>select t1.invoice_sender,t1.ei...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs