DBA Blogs

Process Cloud Service - Using correlations to communicate between processes (part 1)

There are several possible ways to communicate between processes like, request and response, fire and forget, calling sub-processes using call activities. All of those  creates a new process or...

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

Confiqured file watcher isn't started by sy.file_watcher

Tom Kyte - Mon, 2017-08-28 21:26
I created a file watcher job 'fw_job', but it seems the file watcher doesn't start it. "JServer JAVA Virtual Machine" is VALID I granted "CREATE CREDENTIAL" and "CREATE ANY JOB" to my user SYS.FILE_WATCHER FREQUENCY is set to 'FREQ=MINUTELY;IN...
Categories: DBA Blogs

Dynamic SQL with sys_refcursor in Oracle Stored Procedure

Tom Kyte - Mon, 2017-08-28 21:26
Hello Experts, We have created below procedure and need to get result sets for that. Please find below the stored procedure, <b>Stored Procedure:</b> Create or replace procedure test_fetch_details (p_emp_id in employee.emp_id%type, p_emp_cur...
Categories: DBA Blogs

Backup/restore onto other hardware

Tom Kyte - Mon, 2017-08-28 21:26
Hi, I want to make a simple restore / recovery on a new identical oracle (same os(windows), os version and oracle version) (DRP, oracle 11 or 12). DB is in archivelog mode. I have a rman backup in e:\backup (controlfile autobackup is on), nocatal...
Categories: DBA Blogs

Parsing XML with PLSQL

Tom Kyte - Mon, 2017-08-28 21:26
Could you please provide a PLSQL code to parse XML data?
Categories: DBA Blogs

JSON object access using JSON_TABLE

Tom Kyte - Mon, 2017-08-28 21:26
Hi I have a JSON object containing complex MVA, and would like to have relational access to my JSON object using JSON_TABLE + View. The way I am doing it right now, gives me 4 rows when I query the View, and I would like the SQL to return two r...
Categories: DBA Blogs

BITMAP_TREE hint in OUTLINE of DBMS_XPLAN.DISPLAY_CURSOR

Tom Kyte - Mon, 2017-08-28 21:26
Hello, I have a query, somehow (using no_index) I managed to make CBO produce the plan below. It suits my needs however I struggle to understand the hint in the outline (see bolted). <code> Plan hash value: 1166215027 -------------------...
Categories: DBA Blogs

Fast full scan with Index Organized Tables + Function Based Index + Insert

Tom Kyte - Mon, 2017-08-28 21:26
I've noticed I can't seem to force an index fast full scan of a function-based index on an IOT, when it's the source of data for an INSERT. Works fine if it's just a select, or if it's a function based index on a standard heap organized table. Is th...
Categories: DBA Blogs

Error when using DBLINK to SQL Server from Oracle : does not support SYS_OP_C2C in this context

Tom Kyte - Mon, 2017-08-28 03:06
Helloo , I've a problem with read and save data into Oracle Database form SQL Server using DBLINK DG4ODBC. The problem is where clause condition must harcoded. Spec of Table in SQL Server is t_link (NOS NVARCHAR(10), DETAIL_SPEC NVARCHAR(M...
Categories: DBA Blogs

Order by dbms_random.value

Tom Kyte - Mon, 2017-08-28 03:06
Hi tom, To display the random order of rows every time , I give SQL> select object_id from user_objects order by dbms_random.value It displays what I wanted. but if I give SQL> select object_id from user_objects order by .88439942 -...
Categories: DBA Blogs

About show error 'PLS-00103: Encountered the symbol "_" when expecting one of the following' ?

Tom Kyte - Mon, 2017-08-28 03:06
Hi,Chris When i solve Oracle DataGuard physical standby database about GAP's problem,due to most of archived logs have not existed in dynamic performance view 'v$archived_log' and also existed in OS,therefore i need to register these archived logs m...
Categories: DBA Blogs

Handling REP-0108 in Reports runtime. Returning Image based on ID

Tom Kyte - Mon, 2017-08-28 03:06
Respected Sir, i am facing a problem. i have folder which contains .jpg pictures of employees. and in reports i am showing their pictures against their IDs. i am using this function formula. <code> function CF_2Formula return Char is DIRX VARCHA...
Categories: DBA Blogs

Anydata Performance / wrong usage?

Tom Kyte - Mon, 2017-08-28 03:06
Dear AskTOM-Team, It would be great if you can share your opinion on anydata-datatype. Background to my question is, I'm using anydata-Type in conjunction with dbms_sql. To handle a dynamic-sql with their correct datatypes. After a few tests ...
Categories: DBA Blogs

how to send email where email body more than 32 K

Tom Kyte - Mon, 2017-08-28 03:06
Hi, am using utl_smtp.data package and i have some emails where body size more than 32 K, is there any way to send these email in one email? Best Regards
Categories: DBA Blogs

SQL Loader and NLS_LANG

Tom Kyte - Mon, 2017-08-28 03:06
Hi, I need to load into oracle a text file with some decimal number in it. My database recognize the decimal separator as "." and in the flat file numbers are in the format 19.89 The problem is that the pc that I use for the import uses the "," as...
Categories: DBA Blogs

The amazing ANSI join syntax quirk

Flavio Casetta - Mon, 2017-08-28 02:39
Categories: DBA Blogs

Partner Webcast - Private Cloud Appliance & Exalogic

Join us to learn more about Oracle Systems, Engineered Systems and Storage. Learn what we understand by “Cloud Insurance” through our Systems Webcast Series for EMEA...

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

Whether or not to partition tables

Tom Kyte - Sun, 2017-08-27 08:46
My application has tables that are 30-40 GB (130M to 480M records) and indexes (indices) that are 10-25 GB. There is potential for significant growth. Oracle documentation recommends considering partitions when tables grow to 2GB, so I am trying ...
Categories: DBA Blogs

function data type

Tom Kyte - Sat, 2017-08-26 14:26
Hi Tom, I need to create such a function just like, create or replace function (p_name in varchar2(10), p_col1 in varchar2(10), p_col2 in varchar2(10)) is begin select p_col1, p_col2 from p_name; end; / now i need to modify the functio...
Categories: DBA Blogs

Bulk collect into an existing collection that already has data

Tom Kyte - Sat, 2017-08-26 14:26
Can I bulk collect into an existing collection that already has data and preserve the original data? In other words append the new data to the existing data? The output I'm looking for would be (order not important): QWERTY ASDF Haikus are e...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs