Skip to Main Content

Questions

QuestionUpdatedAsked

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...
2 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...
2 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. ...
2 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...
2 hours ago2.4 years ago

Is there a link to information about the ADB-S Strategic Customer Program?...
5 days ago5 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 ...
12 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

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...
2 weeks ago18.5 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

Stats_mode function - Deterministic or Non- Deterministic? What does Oracle return when there are multiple keys with same mode (highest) and how? ...
2 weeks ago1.7 years ago

I have a requirement to create 2 instances and 2 databases on same unix machine. Do I need multiple homes, I think not because it is same version (11g). I already created one instance/database using OUI. Are these steps right for creating second one?1.Login as...
2 weeks ago11.5 years ago

Tom,I am little confused about Oracle Database and instances. If I have created a database DB1, and started it,open for all users, does it mean it is one instance? How can I have multiple instances of a database and how do I find what Instance I am using?So, ...
2 weeks ago13.4 years ago

I looked at v$flashback_database_log and noted there were 300+ logs and all of them except the oldest had a "TYPE" of NORMAL. The oldest log had a type of "RESERVED". That confuses me, and the doc that is supposed to explain what the values in the TYPE col...
2 weeks ago3 weeks ago

Hello,We hit non-public Oracle BUG 7538546 that describes the scenario where COMMIT is NOT DISABLED by command ""ALTER SESSION DISABLE COMMIT IN PROCEDURE" that runs before "AUTHID CURRENT_USER" command in the same package.OracleSupport says this is not a pri...
2 weeks ago3 weeks ago

We have a table with around 150+ million records and our database is setup with two nodes on rac. We can’t do no logging as it’s default setup with logging in prod. We have a requirement to add two columns for this big table and we need to perform update opera...
2 weeks ago3 weeks ago

Hi Tom,Is there a way to automatically add tables a user creates to an audit policy? I'm thinking a trigger could do this, but can we do it without giving the user the AUDIT_ADMIN role? What I am really after is a way to audit any action against a schema.<code...
2 weeks ago3 weeks ago

How to calculate weekly counts with in a year. I want the week to start from Monday to Sunday. Thanks. ...
2 weeks ago3 weeks ago

Hi.I'm using Oracle Analytic Views (from 19c) as defined here: https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic-views.htmlI can create measures with simple aggregations (eg: SUM, COUNT, MIN), but I can't create a measure th...
2 weeks ago10 months ago