DBA Blogs

12cR1 RAC Posts -- 11 : Managing Services in RAC (with PDB) (Video)

Hemant K Chitale - Sun, 2017-05-21 11:01
I have uploaded a video on managing services (add, start, check, remove) in a 12c RAC database with a Pluggable Database.
.
.
.


Categories: DBA Blogs

"SQL Error: ORA-28112: failed to execute policy function": Can't select with VPD.

Tom Kyte - Sat, 2017-05-20 21:06
I'm a newbie at Oracle. Im trying use VPD for my exam. But i could not select with other user. You can see my code above. Sorry about my english.
Categories: DBA Blogs

UNION ALL WITH CURSOR EXPRESSION

Tom Kyte - Sat, 2017-05-20 21:06
Hi Guys...I am new to PLSQL..the below code doesnt seem to work when used with union operator..i have a nested cursor "components" which differ in the first query and the second query.. i pass this as a ref cursor to java. code below (its an exc...
Categories: DBA Blogs

Issue with the update query in oracle

Tom Kyte - Sat, 2017-05-20 21:06
0 down vote favorite I have an update query which is taking 10 hours to update and still it is in the updating stage itself it has about 135171 records only. uPDATE hr.raw_address ora SET (ora.addr_id, ) = (SELECT ...
Categories: DBA Blogs

Extract element from XML Data using SQL

Tom Kyte - Sat, 2017-05-20 02:46
<code>Dear TOM, I like to extract simple data element from XML data using SQL. Could you please help, Option1: SELECT * FROM XMLTable( '/entry/' passing xmltype( '<entry xmlns="http://www.w3.org/2005/Atom"> <id>https://toitest1....
Categories: DBA Blogs

Data Base Date Formats

Tom Kyte - Sat, 2017-05-20 02:46
Hi, I would like to know the Database Character Set and its Default Date Format and language territory details. so would you tell me which table stores those details.
Categories: DBA Blogs

Automating removal of security after duplicate

Tom Kyte - Sat, 2017-05-20 02:46
When performing a duplicate database from prod to dev monthly. We have a script that captures the current user permissions on dev via the dbms package that generates DDL to another file to be used after the duplication. Thus preserving the permissio...
Categories: DBA Blogs

Toggle column value for alternate set of rows

Tom Kyte - Sat, 2017-05-20 02:46
Tom & team, I want to toggle the value in a column to 0 or 1 for alternate set of rows, can you please let me know the optimal way to accomplish this? select empno,dept.deptno, 0 counter from emp, dept where emp.deptno = dept.deptno orde...
Categories: DBA Blogs

Insert All Record Count for different tables

Tom Kyte - Sat, 2017-05-20 02:46
Hi Tom, I am using a multi-insert statement as below in a SQL script. There are around 50 insert all statements like this in my script for different tables. INSERT ALL WHEN FLAG='Y' THEN INTO table1() values() WHEN ...
Categories: DBA Blogs

Extent Sizing for Very Large Segment

Tom Kyte - Sat, 2017-05-20 02:46
We are in the process of reorganizing a large table: 6+ billion rows, almost 500 gigs of space, 126k extents. This table is an audit record so it would rarely --if ever-- get updated or deleted. My question has to do with extent sizing: What would...
Categories: DBA Blogs

ROWNUM Bugs

Tom Kyte - Fri, 2017-05-19 08:26
Hi, i read this below question https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:948366252775 in latest follow up a reader posted like this <code>( 5 years later... select * from X where rownum in (select 1 from dual) sti...
Categories: DBA Blogs

Rownum

Tom Kyte - Thu, 2017-05-18 14:06
Hi Tom I have 2 questions 1. I have a table called a where I have more than one row. When I put a query "SELECT * FROM A WHERE ROWNUM=1" it gives me the first row. But if I put a query specifying any number other than 1 for e.g. "SELECT * FRO...
Categories: DBA Blogs

Making a genric search sql Query

Tom Kyte - Thu, 2017-05-18 14:06
Hi Tom, I have a web application connecting to a Oracle DB. I have a search screen where user can enter any search criterion and submit the information. The information is collected and passed to an Oracle Stored Proc. where a dynamic query is f...
Categories: DBA Blogs

how to create column alias name from the value of another column

Tom Kyte - Thu, 2017-05-18 14:06
Hi Tom, Table structure: empno empname sal balance i had select stmt which will accept date(18-May-2017) as parameter and display the data for date given but column name for balance should be balance_0518 could you please help me in the q...
Categories: DBA Blogs

Datascape Podcast Episode 9 – What’s Up with Oracle These Days?

Pythian Group - Thu, 2017-05-18 09:06

On today’s episode of the Datascape Podcast we are going to talk about the Oracle Database. With the hype around cloud and cloud first initiatives, automation, DevOps, and very specialized cloud-based databases, I wondered what was going on with one of the datascape’s old faithful technologies, Oracle Database.

Joining us is Simon Pane, who is an Oracle consultant and expert. Simon is very much immersed in the community and truly has his feet on the ground. He’s been working in the Oracle DBA space as a consultant for almost his entire career, with a focus around Oracle’s core database technologies. Simon often speaks at various conferences around North America and Europe. He was recently inducted as a board member to Independent Oracle User Group (IOUG), one of the main Oracle user groups.

You can find it on iTunes, Google Play, Sound Cloud, and just about anywhere that shares podcasts.

Key Points From This Episode:

  • Learn more about which types of companies and organizations use the Oracle Database.
  • Understand the different barriers of adoption for using the Oracle Database.
  • Simon shares more about the average size implementation that they see at Oracle.
  • Discover why the main use case for Oracle XE is for teaching and training purposes.
  • Learn more about the current version of Oracle, and the new exciting features.
  • Understand why it is complicated to upgrade an Oracle database, and preparation needed.
  • Simon shares the top features and benefits of the Oracle database.
  • Find out what the ODA and Exadata Appliances are, and the differences between them.
  • Learn more about the Oracle Cloud and how they are working to become a major player.
  • Simon shares his thoughts on Oracle as a product, and whether or not it is dying/dead.
  • Hear about the project that Simon is most proud of, the best tool he uses, and much more!

Links Mentioned in Today’s Episode:

Oracle Database
Oracle Database Appliance
Oracle Exadata
DBA Course
Simon on Twitter
More about Simon
ODTUG
ODTUG Kscope17 Conference

Categories: DBA Blogs

Write Better Code Faster on Oracle Systems (SPARC,x86) with Oracle Developer Studio 12.6

Oracle Developer Studio is the #1 development environment for building C, C++, Fortran and Java applications for Oracle Solaris and Linux operating systems and optimized for Oracle Systems...

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

For Create Serial Number By Employee No. And Year

Tom Kyte - Wed, 2017-05-17 19:46
I Will Create Serial Number by Employee Number Concatenation Year YYYY,For Every Employee to When Create New Transaction Auto Generating Serial Number by Employee number and When Termination Year and begin new year 01-01-YYYY Create new Serial F...
Categories: DBA Blogs

Cannot insert null values to a column defined not null with default constraint

Tom Kyte - Wed, 2017-05-17 19:46
Hi Tom, I'm trying to insert null values to a column defined not null with default constraint . But getting error ORA=01400 Cannot insert null values. Below is the table I created . create table tmp_test( column1 varchar2(10) default 1 not...
Categories: DBA Blogs

INSERT/DELETE on PARENT-CHILD-SUB CHILD table dependency

Tom Kyte - Wed, 2017-05-17 19:46
<code>Hi Chirs/Connor, I have written below procedure to move records from tables (from Primary DB to Arcihval DB). The logic is to merge records on Archival DB then DELETE those rows from Primary as well. We have already have same table struc...
Categories: DBA Blogs

dbms_metadata.get_granted_ddl error

Tom Kyte - Wed, 2017-05-17 19:46
<code>I'm testing some script and suffering from following error script :: set trimspool on; set heading off; set linesize 300; set echo off; set pages 10000; set long 90000; COL DDL FORMAT A10000; EXECUTE DBMS_METADATA.SET_TRANSFORM...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs