DBA Blogs

When does RMAN validate archived redo logs are available during a duplicate?

Tom Kyte - Mon, 2017-10-16 00:26
Does RMAN validate all archived redo logs are available at the beginning of a duplication or once it starts restoring the logs after the backup data files have been restored?
Categories: DBA Blogs

Submitting Questions

Tom Kyte - Sat, 2017-10-14 11:46
Hi Tom, I've been consulting your site for years, and its almost always a source of answers to just about all Oracle issues I encounter. On rare occasions I might encounter an issue not previously discussed, but there's an uncertainty how long I w...
Categories: DBA Blogs

After install of 12,2 on Windows 10, I can only connect as SYS

Tom Kyte - Fri, 2017-10-13 17:26
I have installed Oracle 12c Release 2 twice as a non-container database. The issue I have run into both times is that I keep getting "ORA-01017: invalid username/password; logon denied" every time I try connecting as any user other than SYS. See exam...
Categories: DBA Blogs

How to Create backup table from one schema to another schema every time the live schema table is inserted or deleted or updated

Tom Kyte - Fri, 2017-10-13 17:26
Hi, I want to know How to create a backup table that will backup data from one schema to another schema table every time the live table is inserted or updated or deleted. Awaiting for your response. Thanks, Ershad
Categories: DBA Blogs

Hierarchical query with count of leave attributes

Tom Kyte - Fri, 2017-10-13 17:26
Hello Experts. I want to calculate the sum of the count of the leaves' attributes in a hierarchical query <code> create table hq_test (parent_id NUMBER, child_id NUMBER); INSERT INTO hq_test (parent_id, child_id) VALUES (25,26); INSERT INTO hq...
Categories: DBA Blogs

Execute immediate and passing clob as a parameter is not working.

Tom Kyte - Thu, 2017-10-12 23:06
I have the following procedure <code> create or replace PROCEDURE bscs_rateplan_sync ( tmcode_list IN CLOB, project_id IN VARCHAR2, requestname IN VARCHAR2, v_errm OUT VARCHAR2 ) ...
Categories: DBA Blogs

Differrent Character set and NLS

Tom Kyte - Thu, 2017-10-12 23:06
Hi TOM, Some question on Character set and NLS. 1) What is the different between US7ASCII and WE8ISO8859P1 character set and NLS? 2) Is there any problem for the DB with two diferrent character sets to interact, - trigger - dblink - e...
Categories: DBA Blogs

Auditing Operating system program name

Tom Kyte - Thu, 2017-10-12 23:06
Sir, i am developing a client/server program using VB & Oracle, it is in testing stage. i want to track whether the programmer is doing changes to the database using the application program(VB) or by logging into database(SQLPLUS) for this i us...
Categories: DBA Blogs

How you manage you're work-spaces!!

Tom Kyte - Thu, 2017-10-12 23:06
Greetings Team, I am very curious to know how you actually manage you're work spaces.I mean you always face different kind of questions all day along.How many laptops you use(of course you are using VM). But my question is if you guide someone fo...
Categories: DBA Blogs

SQL * Loader connection errors

Tom Kyte - Thu, 2017-10-12 23:06
To previous answer to MY SQL*Loader question I had asked, you said: Examples of SQL*Loader String <code>sqlldr.exe userid=my_user/my_password@some_string control=my_control.ctl sqlldr.exe userid=scott/tiger@//my_host:my_port/my_service_name con...
Categories: DBA Blogs

ORA-01722: invalid number error in decode

Tom Kyte - Thu, 2017-10-12 04:46
1. select decode('a',1,1,2) from dual --------> O/P Error saying Invalid Number 2. select decode(1,'a',1,2) from dual --------> O/P : 2 what is the difference in the above two cases and also please explain the execution process? Thanks I...
Categories: DBA Blogs

Using Analytical Functions to get Group Total

Tom Kyte - Thu, 2017-10-12 04:46
I need a GROUP TOTAL for EACH MONTH that SUMS up all the values in APPL column even when the query is for a particular APPL value. <code>create table test_grp_total (dttm_month date, appl varchar2(5), mins number) insert into test_grp_total va...
Categories: DBA Blogs

Convert row to matrix and save in table

Tom Kyte - Wed, 2017-10-11 10:26
Good Day I want to ask for your valuable help on a problem that I found, there is a table that stores the information in a single column in Clob format and is copied to another table of a second Oracle Schema, which separates the information with ...
Categories: DBA Blogs

ORA-12560: TNS:protocol adapter error (when running rman backup from scheduler on windows Oracle database)

Tom Kyte - Wed, 2017-10-11 10:26
Hi, I trying to setup a scheduler job on my windows 64bit Oracle database version 12C Below is the script i used where i created OS authentication and create a scheduler to run the backup_script. -- Create a credential so script is run as the co...
Categories: DBA Blogs

Numeric Overflow

Tom Kyte - Wed, 2017-10-11 10:26
I am attempting to Solve some mathematical problems using PL/SQL and I am facing a problem with huge numbers. One such question involves calculating 2 power 1000 (2 power 3 = 2*2*2 => 8). I tried assigning the values to multiple datatypes that I knew...
Categories: DBA Blogs

oracle on linux

Tom Kyte - Wed, 2017-10-11 10:26
i am not well verserd with linux ..i know that we have to write "sqlplus" on the comand prompt in linux to open sql*plus application...is there any place from where i can know how to open other (oracle) applications in linux like "oralce enterprise...
Categories: DBA Blogs

bind variables/ define confusion

Tom Kyte - Wed, 2017-10-11 10:26
Tom, Could you please clarify the DEFINE command in the example below. I am having trouble using the DEFINE command. INPUT: define naming = 'Ivan' insert into emp2 (fname) values (:naming); OUTPUT: Bind variable "NAMING" not declare...
Categories: DBA Blogs

SQLPLUS query output to *.csv or *.txt format

Tom Kyte - Wed, 2017-10-11 10:26
Hello Tom is there anyway to do a query in sql*plus, then have the result output to a file in *.csv or .*.txt format without invoking UTL_FILE, using only sql*plus command. I'm not allowed to creat any procedure. PS: this link "http://asktom.ora...
Categories: DBA Blogs

Partner Webcast – Achieve Database High Availability and Disaster Recovery with Oracle Cloud

The High Availability and Disaster Recovery needs of customers traditionally have required significant capital investment in the infrastructure that provides the redundant capabilities that are...

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

Second Highest Sal

Tom Kyte - Mon, 2017-10-09 21:46
Hello Tom, How are you, After long time i visited the site and able to find the button. Ok Here is my question how can i get from sql second highest salary record from the table but with deparment wise Ram 10 1000 Jai 10 2000 San 20 3000...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs