DBA Blogs

Joining two tables with time range

Tom Kyte - 1 hour 31 min ago
Dear AskTom-Team! I wonder whether it is possible to join two tables that have time ranges. E.g a table 'firmname' holds the name of a firm with two columns from_year and to_year that define the years the name is valid. Table 'address' holds the a...
Categories: DBA Blogs

TDE Encryption of local Oracle databases. KEK hosted on cloud service?

Tom Kyte - 1 hour 31 min ago
Hi, We want to encrypt some on-premise Oracle databases. If possible, we would like to avoid to use a physical HSM or to contract with a third party HSM cloud provider. Is this possible to store the KEK's in GCP or Azure, and to interface our lo...
Categories: DBA Blogs

Migration from oracle 6i and 11g to Oracle APEX

Tom Kyte - 1 hour 31 min ago
Dear all, i have oracle forms that are built on 6i and 11g and i want to migrate them to oracle apex, is it possible to create an application based on the oracle 6i form migrated, if so can you provide me with a document or a video showing the pro...
Categories: DBA Blogs

One way Encryption where no one can decrypt

Tom Kyte - 1 hour 31 min ago
Hi Tom, Kindly suggest some one way encryption for the data in table,where no one can decrypt it? Read few articles about this and not satisfied. Kindly help.
Categories: DBA Blogs

Connection retry when database services failover

Tom Kyte - 1 hour 31 min ago
Hello, Ask Tom, Team. I have a two-node RAC running a database service with one preferred instance and one available instance. It is supposed that RAC automatically failovers the services to available when preferred instance crashes. 1. Will ...
Categories: DBA Blogs

Best Practice using database services

Tom Kyte - 1 hour 31 min ago
Hello, Ask Tom Team. We have a two-node RAC running a database. The app connects to the database using scan name (best practice), so we are not using vip to connect to database directly. The tnsnames.ora is: DBPROD = (DESCRIPTION = (ADD...
Categories: DBA Blogs

Impact of Index Monitoring in production server

Tom Kyte - 1 hour 31 min ago
Hi, we are planning to change global index to local index for partitioned table in production. Since we need to drop an index and create it again and we don't know the time it will take, we decided to monitor the index which are being used by the app...
Categories: DBA Blogs

Generating DDL in Oracle SQL Developer

Tom Kyte - 1 hour 31 min ago
Dear AskTom-Team! Is there a possibility in the Oracle Developer to suppress duplicate DDL code? For example when generating the DDL from my relational model the foreign key constraint is generated twice, i.e. for both tables that are involved in th...
Categories: DBA Blogs

Oracle Database Views and Tables for Oracle GoldenGate

DBASolved - Fri, 2019-11-08 16:40

Oracle GoldenGate for Oracle over the last few releases have been moving towards an integrated architecture.  This means that there is more views and tables within the Oracle Database that support Oracle GoldenGate.  You can quickly find these views and tables by using a where clause with a filter for GoldenGate: select * from all_views […]

The post Oracle Database Views and Tables for Oracle GoldenGate appeared first on DBASolved.

Categories: DBA Blogs

Clustered Indexes

Tom Kyte - Fri, 2019-11-08 02:48
Is clustered Index is faster than Non-clustered Index?
Categories: DBA Blogs

Platform list on whicb JAVA_JIT_ENABLED paramter can be enbaled

Tom Kyte - Fri, 2019-11-08 02:48
<b>Question:</b> As my application is using some JAVA function as UDF using <b>loadjava</b>. So, developers are suggesting to set <b>JAVA_JIT_ENABLED</b> parameter as <b>true</b>. I have read (https://docs.oracle.com/cd/B28359_01/server.111/b28320/in...
Categories: DBA Blogs

How can i extract data from a URL string in SQL?

Tom Kyte - Fri, 2019-11-08 02:48
Hi TOM, i am trying to extract some data from a URL and running into some issues. The URL's will look something like this: http://192.168.201.242:8000/express_get?time=$startDate&from=$phoneNumber&to=$CAMPAIGN&Id_agent=$idExternalUser&spent=$durat...
Categories: DBA Blogs

JAVA CLASSPATH Specificaiton

Tom Kyte - Fri, 2019-11-08 02:48
Hi, We have an Oracle 10g database running java on the database as java stored procedures. It is hosted on an IBM AIX frame. There are both 64bit and 32bit jvms installed. How do you specify the java classpath for java running in the database? W...
Categories: DBA Blogs

Cursors

Tom Kyte - Fri, 2019-11-08 02:48
Hi Tom, The Oracle users in the world should be thankful to you for all your help all the way .Many thanks for that. We are learning many things about Oracle that we could not learn by reading several Oracle books (other than your books) though ...
Categories: DBA Blogs

Alternate to pro*c batch programming

Tom Kyte - Fri, 2019-11-08 02:48
Dear Team, We would like to have suggestion on the topic related to alternate programming for the existing batch system in pro*c with oracle 12c database. Currently we have many number of batch jobs which are in pro*c (by interacting with oracl...
Categories: DBA Blogs

Create materialized view with ENABLE QUERY REWRITE for SDO_RELATE getting ORA-30373

Tom Kyte - Fri, 2019-11-08 02:48
I write a query like this: <code>CREATE MATERIALIZED VIEW MV REFRESH FORCE ON DEMAND start with (sysdate) next (sysdate+1/1440) ENABLE QUERY REWRITE AS SELECT O.ID DIREK_ID, MAX(LK.ADI) ISLETME_GERILIMI FROM xxx O, yyy AA, SY...
Categories: DBA Blogs

Copy row value down until next non-null row

Tom Kyte - Fri, 2019-11-08 02:48
Hi, Is there a simple way to achieve the following output in SQL? Wanted to populate the null values with the Country name until there is a new country name. Thanks with data as ( select 'Afghanistan Afghani' as country_currency, N...
Categories: DBA Blogs

Problem with very large varchar2 sorting in oracle 10g r2? Sorry, I can't verify my problem in LiveSQL because I need to run it in Oracle 10g r2

Tom Kyte - Fri, 2019-11-08 02:48
I am very sorry to waste your time with something that is probably VERY SIMPLE, but IT IS something I cannot understand ... I must be obfuscated <code>select level, lpad(to_char(level), 1000) from dual connect by level<=20 order by 2;</code> ...
Categories: DBA Blogs

Change column to row

Tom Kyte - Fri, 2019-11-08 02:48
I have a data like below in a table <code>create table test ( sr varchar2(1),col1 number,col2 number,col3 number ) ; insert into test values ('a',1,2,3); insert into test values ('b',4,5,6); insert into test values ('c',7,8,9);</code> Want...
Categories: DBA Blogs

Which is Bigger – KB or MB?

VitalSoftTech - Tue, 2019-11-05 09:49

A computer noob like myself often gets confused about storage units in terms of the memory of a computer. All these KBs, MBs and GBs boggle my mind. Does that happen to you too? The question that baffles me the most is, which is Bigger – KB or MB? In addition to answering this question, […]

The post Which is Bigger – KB or MB? appeared first on VitalSoftTech.

Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs