Skip to Main Content

Questions

QuestionUpdatedAsked

Hi, is delayed Data Guard in the roadmap for Autonomous database? I've a customer concerned about ransomeware attacks so they want a time gap on their ADG. They are in Amsterdam and will run Cross region ADG to Frankfurt, but would like to have a possiblity to...
5 hours ago5 hours ago

We have a table called PROTOKOLL, with the following definition:<code> CREATE TABLE "PROTOKOLL" ( "UUID" CHAR(36 BYTE) NOT NULL ENABLE, "VERSIONSNUMMER" VARCHAR2(20 BYTE), "TYP" CHAR(1 BYTE) NOT NULL ENABLE, "BENUTZER_ID" VARCHAR2(250 BYTE) NOT NULL ENA...
8 hours ago4.7 years ago

Hello1.What is a deadlock and how can i detected, how can i fix a deadlock??2. I've a temp tablespace with 3 GB of size, acording to the high water mark anly have been use about 300 MB of the file, i try to resize to 1.5 Gb but it doesn't let me, why is that??...
8 hours ago20.3 years ago

<code>insert /*+ append */ into tselect rownum,mod(rownum,5)from all_objectswhere rownum <=1000call count cpu elapsed disk query current rows------- ------ -------- ---------- ---------- ---------- ---------- ----------Parse...
9 hours ago14 years ago

Tom,I am trying to calculate mean, median, and mode of salary within each department, and display it on all rows (corresponding to the department). It's fine to ignore rows with a null salary. I believe I've got mean and median, but I need help with mode. B...
9 hours ago18.5 years ago

hi TOM,please tell me, what is the opposite for INTERSECT?...
9 hours ago5.1 years ago

Could you explain me about Key-preserved table conceptin join views.i know that a table is ket preserved if every key of the table can also be a key of result of the join.but i not understand meaning of this.Thanks ...
18 hours ago22.1 years ago

Tom, I was working with External tables and Oracle came up with an error when I tried to insert, update or delete from external tables, as shown below.SQL> delete from student_ext;delete from student_ext *ERROR at line 1:ORA-30657: operation not su...
19 hours ago20.3 years ago

Hi Tom I enjoy reading your site. I learned lot of tricks from your site. I need to write a SQL to group the data in ranges.Below is the dataSite_no tot_rec1001 100001002 200001003 305001004 500001005 250001006 360001007 280001008 21000For every runnin...
19 hours ago10.8 years ago

Hi, <code>create or replace function f_get_ids(p_user in nvarchar2)return nvarchar2 sql_macro(table)asbegin return q'[select id from table1 where user=p_user]';end;</code>Error(1,27): PLS-00103: Encountered the symbol "(" when expecting one of the following: ...
19 hours ago7 months ago

Hi, We are running PeopleSoft and ocassionally we get error: ORA-01460: unimplemented or unreasonable conversion requested. There is nothing in the alert.log file and we can move past the error by just restarting the failed process without making any changes...
38 hours ago5.7 years ago

Hello Chris/Connor,I am trying to use the option MY_WALLET_DIRECTORY in TNSNAMES file in order to avoid having to specify WALLET_LOCATION in SQLNET.ORA file. However, it fails with ORA-01017: invalid username/password; logon denied error. Tracing the SQLNET (f...
38 hours ago1.3 years ago

hi tomcan u explain me in detail about "start with connect by" sql statement (tree structure).i know there is documentatin but it is very confusing. ...
38 hours ago21.5 years ago

The objective is to create an apex application where information updates in real time on a user's page automatically as the result of changes made in the database or in the application by another user signed on somewhere else. For example order processing, pe...
38 hours ago2.4 years ago

Is there a link to information about the ADB-S Strategic Customer Program?...
7 days ago7 days ago

Tom,Thanks for providing this forum for answering questions. I'm trying to get the hang of analytic functions and I'm having a problem with the following code. I have to comment out "where dr <= 3)" to get it to work. "dr" shows up as the column heading but I ...
13 days ago20.5 years ago

Database(non-CDB) version - 18.8.1.0.0TDE is enabled, Wallet_location is in ASM, software keystore is configured and auto-login is created. Only tablespace encryption is enabled at the moment.Backup of the encryption keys (ewallet.p12 & cwallet.sso) is taken ...
2 weeks ago2.4 years ago

TomOne of our main dissapointment is that , we cannot use analytical functions in sql from within a procedure, as they are not compatible with the pl/sql engine.Further, when I try to update my knowledge with the analytical functions, I get the doubt as to th...
2 weeks ago20.9 years ago

Hi Tom I hit a problem, when gen DDL statement using DDL command in sqlcl tools. Follow with my environment: (1) Redhat (2) Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production(3) SQLcl: Release 4.2.0.17.097.0719 ProductionIn the datab...
2 weeks ago5 years ago

<code>Hi,I have a requirement to implement the following:Create table marker(code varchar2(4),sid integer (10),mrk1 char(4),mrk2 char(4),mrk3 char(4),mrk4 char(4),mrk5 char(4),mrk6 char(4))Create table candidate (code varchar2(4),sid integer(10))Create table c...
2 weeks ago5.3 years ago