DBA Blogs

Synchronous refresh cannot be used for the non-partitioned tables?

Tom Kyte - Thu, 2016-08-25 23:06
Hi, as I want to use the new technology in 12c called "Synchronous refresh" of the MView or group of MViews, I read the documentation ( https://docs.oracle.com/database/121/DWHSG/sync.htm#DWHSG029 ), but for me it's not 100% clear what are the res...
Categories: DBA Blogs

The last query gives the error "Invalid Identifier error".Please explain me whether I have refer the correct table?

Tom Kyte - Thu, 2016-08-25 23:06
---------------------types------------------- create type course_ty1 as object( cid number, titlte varchar(15), credits_req integer ) / create type unit_t as object( ui number(5), credit number(5) ) / create type offering_t as obj...
Categories: DBA Blogs

Partner Webcast – Oracle Big Data Preparation Cloud Service: Transform to Self Service Data Preparation for Business Users

When you work with data, the perception is that you spend most of your time on analytics. But in reality, you will devote much more time and effort on importing, profiling, cleansing, repairing,...

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

Future of Oracle PL\SQL

Tom Kyte - Thu, 2016-08-25 04:46
Hi Tom, I am working as PL\SQL developer, I wants to know the future job opportunities for PL\SQL,else whether I needs to update my skills in some other technology to survive in IT industry? Kindly do me suggestion. Thanks, Ganesh
Categories: DBA Blogs

Insert statement finished as per user_segment table but session is not releasing control

Tom Kyte - Thu, 2016-08-25 04:46
Hi Tom, I need to dump data into a temporary table where I do not need to have any data foreigh key, primary key. I kept the table in NOLOGGING mode with parallel 4. I am inserting with /*+ APPEND */ direct path insert. The data is getting inserte...
Categories: DBA Blogs

Oracle SQL Developer

Tom Kyte - Thu, 2016-08-25 04:46
I have a query that returns 50,000 records, how can I quickly get to the last record? if I use the scroll arrow of slide, it takes a long time before it gets to the bottom of the 'Query Results" is there a quick way to go to the last record? I hop...
Categories: DBA Blogs

Identifying only new characters entered in a varchar2 field

Tom Kyte - Thu, 2016-08-25 04:46
I need to write a query that will extract only new characters appended in a text field. Almost like auditing but done by query. Example Select field1 from table1; the dog is running in the park user appends more data into field1 via applicati...
Categories: DBA Blogs

ORA-00201: control file version 11.2.0.0.0 incompatible with ORACLE version 10.2.0.0.0

Tom Kyte - Thu, 2016-08-25 04:46
Hi Tom, We took a backup of prod database running on 11.2.0.4.0 and refreshed it on test database running on 10.2.0.4.0. We are unable to start to start our 10g database and receiving an error. We don't have a backup of our controlfiles as they ar...
Categories: DBA Blogs

File IO Stats - AWR

Tom Kyte - Thu, 2016-08-25 04:46
Hi team We have database showing "Av Rd(ms)" in File IO Stats section of the AWR as high as 500 msec. asvc_t ( SERVICE time) value of iostats data for the mount point is well within the acceptable 20 msec. 1) could you please share the sq...
Categories: DBA Blogs

SGA Size

Tom Kyte - Thu, 2016-08-25 04:46
Hi Team, What are the factors (list) that suggest we should increase the size of the SGA allocated for a database.
Categories: DBA Blogs

csv to oracle with multiple delimiter

Tom Kyte - Thu, 2016-08-25 04:46
I have a CSV file with no break, there is a |~| symbol as a column separator and |~~| has a row separator and ; is the single colum value seperator . I want to insert it into oracle table using utl_file please help . sample data is fname|~|mname...
Categories: DBA Blogs

when I am querying V$Datafile, I am seeing an entry with unrecoverable_change#

Tom Kyte - Wed, 2016-08-24 10:26
Hi team, when I am querying V$Datafile, I am seeing an entry with unrecoverable_change# as below we dont have any Primary standby configuration and this is Standalone DB. 1. how this Column updated (UNRECOVERABLE_CHANGE#) ? FILE# CREATION...
Categories: DBA Blogs

Memory_target and Memory_max_target

Tom Kyte - Wed, 2016-08-24 10:26
Hello Tom, I have very silly question for an experience person in oracle. but i am totally confused. please help As per my knowledge, memory_target is the parameter which oracle use to tune sga and pga components. and Memory_max_target is the p...
Categories: DBA Blogs

Clob EXTRACTVALUE over 4000 char limit

Tom Kyte - Wed, 2016-08-24 10:26
I am trying to extract a piece of text from a clob attribute that has descriptions in it. The problem I am encountering is when the description is over a certain number of characters, I believe 255 char, it fails and throws the error: <i>ORA-...
Categories: DBA Blogs

Transaction Isolation level - Serialization

Tom Kyte - Wed, 2016-08-24 10:26
Hi, I know its not recommended to use transaction isolation level as Serialization but for now we have to stick with it. Please pardon my knowledge as I'm new to this. I currently use Sybase ASA (SQLAnywhere) where we have the isolation level ...
Categories: DBA Blogs

Is it possible to use occi client of oracle11 to fetch/write extended data types that were added in oracle 12c?

Tom Kyte - Wed, 2016-08-24 10:26
Hi, I use oracle11 client library (libocci.so.11.1) to work with extended data types, like RAW(32000), VARCHAR(32000), etc. This is a new feature of Oracle 12c. When I try to fetch RAW data, I get exception: ORA-01461: can bind a LONG value on...
Categories: DBA Blogs

Partition pruning/elimination -reg..

Tom Kyte - Wed, 2016-08-24 10:26
Dear Tom, Sorry for the delay. 1 CREATE TABLE emp (no number, name VARCHAR2(10) , 2 PRIMARY KEY (no, name)) 3 partition by hash(no) 4 ( 5 PARTITION PART1 TABLESPACE "TS1" , 6 PARTITION PART2 TABLESPACE "TS2" 7* ) ...
Categories: DBA Blogs

Links for 2016-08-23 [del.icio.us]

Categories: DBA Blogs

Update using subquery with group by

Tom Kyte - Tue, 2016-08-23 16:06
Hi Tom I have a table with 18 million rows. I need to do an once-off update to fix a data issue. CREATE TABLE TESTLARGE(CODE number, STATE varchar2(5), SDATE date, flag char(1)); This table does not have any primary key enforced. I have t...
Categories: DBA Blogs

problem with a few chjaracters in JAVA / JDBC that cant be converted from source 9i solaris DB to a 12c linux system

Tom Kyte - Tue, 2016-08-23 16:06
Hello Tom, 1.what is the right superset for WE8DEC?? 2. what OS charset (say I would it set in my java program) should by set if I want to read varchar fields and write them in a new varchar field? Apart from this they received "ORA-29345:...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs