Feed aggregator

Adjust connections/sessions Oracle database

Tom Kyte - 44 min 32 sec ago
Hello, Ask Tom Team. I have a production database running for several months. These are my connection parameters in the client to connect to the database (RAC 18c). I am using a .NET app. Min Pool Size=1;Max Pool Size=60;Connection Lifetime=18...
Categories: DBA Blogs

Regarding Oracle Error ORA-26002 table has index defined upon it

Tom Kyte - 44 min 32 sec ago
Hi There, This is regarding the error ora-26002 which we are facing since few days. We have one table T1 which is having an index on one of the column. This table T1 is being loaded through informatica using bulk mode option. (Without droppi...
Categories: DBA Blogs

Oracle 18c SQL Query Pagination

Tom Kyte - 44 min 32 sec ago
Hello, Ask Tom Team. I am building a report using Microsoft SQL Server Reporting Services connecting to an Oracle 18c database. This report will show lots of data. I need to paginate the results, showing 50 rows per page. 1. How can I do i...
Categories: DBA Blogs

Online Table move to different table space.

Tom Kyte - 44 min 32 sec ago
Team, we are on 18c and trying to move a table to a different table space, using the online move it got failed like this. <code>c##rajesh@PDB1> alter session set ddl_lock_timeout =300; Session altered. c##rajesh@PDB1> show parameter ddl_l...
Categories: DBA Blogs

Oracle Database + Git = Gitora 4

Gerger Consulting - Thu, 2020-04-02 15:17

We are happy to announce the new version of Gitora, the version control tool for the Oracle Database.

Gitora 4 enables you to manage your entire Oracle code base with Git. New features in Gitora 4 include:
  • Push to and pull from repositories in GitHub, GitLab, Bitbucket etc...
  • Simplified workflow and vastly improved working directory structure
  • SQL Developer Extension (Coming soon.)

Categories: Development

PL/SQL Machine Code Trace - event 10928

Pete Finnigan - Thu, 2020-04-02 11:06
I have had an interest in PL/SQL for more around 25 years. I have always liked this great language as its powerful and simple and a great tool for writing code in the database. I wrote my very first PL/SQL....[Read More]

Posted by Pete On 02/04/20 At 01:33 PM

Categories: Security Blogs

Database Link Issues: Adding schema name raises ORA-02002: error while writing to audit trail ORA-00942

Tom Kyte - Thu, 2020-04-02 11:06
I have a database link that connects to a databases that is running 11g ( The database it is created in was recently upgraded to 19c. After the upgrade, I can no longer access remote tables using fully qualified table names. Prior ...
Categories: DBA Blogs

VM username and password

Tom Kyte - Thu, 2020-04-02 11:06
I require password and username for oracle db developer virtual machine for training purpose
Categories: DBA Blogs

Generate version number

Tom Kyte - Thu, 2020-04-02 11:06
How to Generate version Number using oracle SQL like rownum?? Need Result Like this <b>0.7,0.8,0.9,1.0,1.1,1.2</b> upto 4.5
Categories: DBA Blogs

Second run of calling webservice using UTL_HTTP fails with ORA-12535: TNS:operation timed out

Tom Kyte - Thu, 2020-04-02 11:06
Hi Tom, Please help me in addressing this issue. I am using the below procedure to call HTTPS wsdl, this works fine for the first time when calling this procedure on SQL prompt logging into DB server(AIX) via Putty. But fails when I try to ex...
Categories: DBA Blogs

Timestamp validation against current timestamp

Tom Kyte - Thu, 2020-04-02 11:06
Hello, I am a newbie developing an app on APEX 19.2. I have a table with a field <b>START_DATE</b> of data type <i>TIMESTAMP WITH LOCAL TIME ZONE</i>. I also have a form with this field, for which I have specified <b>Identification Type</b> as Da...
Categories: DBA Blogs

How "ONLINE" is an "alter table move ONLINE" in 12.2 and beyond?

Tom Kyte - Thu, 2020-04-02 11:06
Good Morning, It seems like Oracle has made some significant improvements to the "alter table move ONLINE" command in 12.2. For a basic heap table that is made up of varchar, char and number data types with a few b-tree indexes, it seems like we ...
Categories: DBA Blogs

Oracle 11g select query with Json field

Tom Kyte - Thu, 2020-04-02 11:06
I want to fetch data from below table. Table Name: Insight <code>Id | Name | JSON_DATA ----+------------+------------------------------------------------------------- 1 | Sitansu. | {"country_codes": ["IND"], "regions": ["ASIA"]...
Categories: DBA Blogs

Log errors

Bar Solutions - Wed, 2020-04-01 23:48

Just a quick note of something I ran into at my current assignment. I have to import data from external tables into persistent tables. This proces normally is just inserting data into the table, but sometimes a file can be sent in more than once.

Originally I thought I would add the /*+ APPEND */ hint to the statement to speed things up. This works flawlessly as long as you are just inserting new records. As soon as you try to insert a record which already exists you can hit a unique constraint (or some other constraint) (if defined). So my next idea was to use the LOG ERRORS construction. As soon as you hit an error for a specific record, it will record it in a separate table and continue with the next record.

But…This doesn’t work when combined. As soon as you add the /*+ APPEND */ hint, the LOG ERRORS line seems to be ignored.

Be Careful of What You Include In SQL*Net Security Banners

Pete Finnigan - Wed, 2020-04-01 16:46
A short post today to add a little to the post I made the other day. In that post Add A SQL*Net Security Banner And Audit Notice I talked about using the sqlnet.ora parameters SEC_USER_AUDIT_ACTION_BANNER and SEC_USER_UNAUTHORIZED_ACCESS_BANNER to add security....[Read More]

Posted by Pete On 01/04/20 At 11:50 AM

Categories: Security Blogs

Plain SQL text on cloud platform - SQL Injection and Data security standards

Tom Kyte - Wed, 2020-04-01 16:46
Hello TOM, I need to know if query through plain SQL text is accepted on cloud platform from data security standards perspective. How about SQL injection bugs/security risk for on cloud platform? Plain sql (like exec reporting_view_generato or s...
Categories: DBA Blogs

Oracle Therapeutic Learning System Records Effectiveness of COVID-19 Drugs

Oracle Press Releases - Wed, 2020-04-01 11:18
Press Release
Oracle Therapeutic Learning System Records Effectiveness of COVID-19 Drugs

Redwood Shores, Calif.—Apr 1, 2020

For the last several weeks, Oracle has been actively engaged in the ongoing fight against COVID-19. Our primary goal has been to develop and deploy a series of cloud applications that will gather the data necessary to enable health professionals to answer one critical question: What drugs are effective in treating or preventing the COVID-19 virus?

Clinical Trials System

The first systems we implemented in pursuit of this goal were clinical trials. Oracle has long been one of the world’s leading suppliers of clinical trial systems. Over the years, many drugs including the remarkable cancer drug Keytruda have been approved by regulators worldwide after Oracle Clinical Trial Systems collected the data that proved the drug was both safe and effective. As of today, the Oracle Cloud is running clinical trials to test the safety and effectiveness of dozens of different COVID-19 drugs and vaccines. These trials span many countries and hundreds of institutional sites. Our newest cloud system named Clinical One enables institutions to start-up a clinical trial in as little as two weeks…much much quicker than ever before.

Therapeutic Learning System

In addition to gathering data from COVID-19 clinical trials, Oracle has built and donated to the US government a COVID-19 Therapeutic Learning System that allows physicians and patients to record the effectiveness of promising COVID-19 drug therapies. These drugs, like Hydroxychloroquine, Remdesivir, and Kaletra, have been safely used to treat other diseases but are not yet definitively proven to be effective against COVID-19. Physicians are now routinely prescribing these drugs to treat COVID-19 patients. The Oracle Therapeutic Learning System lets the physician record the patient's daily progress. By collecting this real-world patient data throughout the United States now, and throughout the world soon thereafter, we will quickly discover which of the new drugs are most effective against COVID-19, their optimal dosages, and how early in the disease progression the drugs need to be administered. In this way, each patient will participate in the fight against this deadly virus.

The Therapeutic Learning System was the result of a unique and important collaboration with the National Institute of Health, the Food and Drug Administration, the Center for Disease Control and Prevention, Centers for Medicare & Medicaid Services, and the Department of Health and Human Services. Doctors and patients started enrolling in the Therapeutic Learning System yesterday. The system is currently available to every physician in the United States at covid19.oracle.com

Contact Info
Jessica Moore
Oracle Corporate Communications

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Jessica Moore

  • +1.650.506.3297

[AZ-400] Microsoft Azure DevOps Training: Step By Step Activity Guides/Hands-On Lab Exercise

Online Apps DBA - Wed, 2020-04-01 10:26

Are you looking for information on the Hand-On Labs one should perform to become a Microsoft [AZ-400] Certified Azure DevOps Engineer? If YES, then check out K21Academy’s blog post at https://k21academy.com/az40005 that talks about all such Hands-On Labs in detail. Begin your journey towards becoming a Microsoft [AZ-400] Certified Azure DevOps Engineer and earning a […]

The post [AZ-400] Microsoft Azure DevOps Training: Step By Step Activity Guides/Hands-On Lab Exercise appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

[AZ-900] Microsoft Azure Fundamentals: Cloud Computing – Overview & Benefits

Online Apps DBA - Wed, 2020-04-01 09:26

Cloud Computing is the on-demand availability of computing services including servers, storage, databases, networking, software, analytics, and intelligence over the Internet. Are you interested in knowing more about Cloud Computing? If YES, then check out K21Academy’s blog post at https://k21academy.com/az90012 that covers: • Cloud Computing Overview • Benefits of Cloud Computing • Sample Questions & […]

The post [AZ-900] Microsoft Azure Fundamentals: Cloud Computing – Overview & Benefits appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Oracles Free TNS Firewall - VALIDNODE_CHECKING

Pete Finnigan - Tue, 2020-03-31 22:26
I said in a post a couple of days ago that my overall plan to secure an Oracle database; actually my plan is to secure the data in an Oracle database not blindly just secure Oracle. We must focus on....[Read More]

Posted by Pete On 31/03/20 At 12:26 PM

Categories: Security Blogs


Subscribe to Oracle FAQ aggregator