Questions tagged [oracle]

All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.

Filter by
Sorted by
Tagged with
0 votes
1 answer
10 views

Select function-based index data as rows in a query?

I'm trying to learn about indexes in Oracle 18c. As a novice, it's occurred to me that it might be interesting to view the actual data that's in a function-based index: create index ...
user avatar
  • 1,373
2 votes
2 answers
28 views

Rotate passwords with zero down time

Big question: How to rotate passwords in an Oracle database in a zero downtime (ZDT) way? My current thought is to rotate the users. Originally, I had MY_USER that had all the tables and such. Now, ...
user avatar
  • 121
0 votes
1 answer
21 views

How to grant select on v$session to a common user see all session of all pdbs?

I've done it': grant select on sys.gv_$session to c##dba_foo container = all; But I can't see sessions from pdbs. Also, the c##dba_foo need permission to kill others session of all pdbs. Do I need ...
user avatar
  • 506
0 votes
0 answers
22 views

Oracle 12c common user - ORA-01017: invalid username/password; logon denied

Why I am not abble to connect to the database with an account I just create? SQL> alter user c##fooo identified by foo123; User altered. SQL> conn c##fooo/foo123 ERROR: ORA-01017: invalid ...
user avatar
  • 506
-2 votes
1 answer
26 views

Running an O/S script from DBMS_SCHEDULER

Have a need to run an O/S bash script from an Oracle 19.6 database. Here is my test case on my test database: I want it to write out to a file, but right now I can't even get the job to run. SQL> ...
user avatar
  • 187
0 votes
1 answer
28 views

Drop the constant recurring JOINs in SQL queries on a SQL-Server, is this possible?

I would like to show the columns of "linked" tables in SQL-Server database. In my particular case, there are two tables "Loads" and "Locations", linked by Loads....
user avatar
  • 333
0 votes
0 answers
31 views

Using renamed Column in WHERE clause with Comparison Operator

Question: show all jobs where max salary stays under 10000 even with a 25% increase. This is my first week learning SQL so I don’t know very much yet but this is my statement: SELECT job_title, ...
user avatar
-1 votes
0 answers
6 views

AWS Postgresql RDS to OCI Postgresql Database Real Time Replication

Good day, our organization is planning to have a DRP cloud provider which is OCI. Is it possible to implement the REAL TIME syncing of data from AWS PostgreSQL RDS to OCI PostgreSQL Database?? If yes, ...
user avatar
0 votes
1 answer
30 views

Postgres equivalent of Oracle's RMAN.VALIDATE_DATABASE

I am migrating a system using Oracle DB to Postgres (12.7). Various checks are run weekly against the existing DB, including a RMAN.VALIDATE_DATABASE (actually RDSADMIN.RDSADMIN_RMAN_UTIL....
user avatar
-1 votes
1 answer
38 views

ORACLE PL/SQL - using decode

I need to list all undo tablespace names in an Oracle (19c) database (regardless of whether they're used or not) from the ts$ table. My SQL statement below gives that info but it also lists all the ...
user avatar
  • 29
-2 votes
0 answers
37 views

why I cant install the Oracle database (21c,19c etc) . I have met all the following requirements

I have jdk11,oracle sql developer and oracle virtualbox downloaded. Why I cant install the Oracle database(21c,19c etc). I have met all the following requirements: have the Windows 11 pro edition. ...
user avatar
-1 votes
1 answer
24 views

Deleting duplicate value in View from the Base table

BASIC INFO : I have a table : YARDI_PROPERTY -> PK -> HMY, and a VIEW which uses HMY from it. Issue : Getting duplicate HMY in the view. Requirement : TO delete those duplicates. IMPLEMENTATION :...
user avatar
0 votes
1 answer
21 views

Creation Synonym among different db schemas

might seem a stupid question, but I'm pretty new to the db world. Is that a good practice to have two oracle schemas which have synonyms pointing to each other ? like SCHEMA_A owns a SYNONYM_1 ...
user avatar
  • 1
0 votes
1 answer
28 views

How to store files for thick client app

How to correctly store files for thick client app (Ora DB <-> Win App)? A) If we store files in DB, DB is hard to manage and, as I understand, violates best practices. B) If we store files on ...
user avatar
0 votes
0 answers
9 views

Enterprise manager - ASH graph

I'd like to know the numbers in the left the graph also have some relationship between the amount of active session waiting an event, For example: Usually seem be only the load of the machine, but ...
user avatar
  • 506
-1 votes
2 answers
35 views

Struggling with improving efficency of this code

QUERY FOR COLUMN INSIDE A VIEW(need for this to work faster) CREATE OR REPLACE VIEW "ODS"."VW_YARDI_DLR_PROPERTY_INFORMATION" ("SPCODE", "HMY", "SPNAME&...
user avatar
-1 votes
0 answers
19 views

Need help with query

I have a code which uses left join but it is very slow, similarly I wrote what exactly Left join does using UNIONS it is much faster. LEFT JOIN CODE : ` SELECT DPI.dOwnershipPercent AS ...
user avatar
0 votes
0 answers
13 views

IMPDP causing ORA-39002 with no subsequent message

In the past, I've seen ORA-39002 followed by subsequent errors providing more detail on the issue. In this case, I get no other information in the console or in the logfile that is created in my ...
user avatar
0 votes
0 answers
34 views

Oracle - How to Set Table and Index Statistics on empty table in order to test out explain plans?

I have an empty table with some indexes. I would like to test out different queries on this table to verify the explain plan is behaving as expected. Normally I would insert a large amount of fake ...
user avatar
0 votes
0 answers
13 views

Some easy way to list OS disks used by ASM without use asmcmd or sqlplus?

For example: I can list the disks with kfod: [root@rac1 bin]# ./kfod op=disks status=true disks=all dscvgroup=true -------------------------------------------------------------------------------- ...
user avatar
  • 506
0 votes
0 answers
29 views

startup database not coming up srvctl database status up and runinng

Prod db not coming up when starting up. I h ave done shutdown and then now starting up but db is not coming up below error SQL> startup ORA-39510: CRS error performing start on instance 'TSU' on '...
user avatar
  • 1
1 vote
2 answers
23 views

Problem with Oracle Job Scheduling

I have a job that refreshes a materialised view refresh group on Oracle 19c. I wanted to refresh the group daily at midnight - trunc(sysdate)? The job was made using using the following PL/SQL: ...
user avatar
  • 137
-1 votes
0 answers
17 views

SQL Server Question Stored Procedures and contuous delployment Azure DevOps

Background: We hare migrating from oracle to sql server. We have a LOT of stored procedures that live in packages. We have a lot of of packages as well. Packages usually are tied to a main application....
user avatar
  • 1
-1 votes
1 answer
29 views

Buttons in a report are not working in oracle application apex

I tried to create a form with report page in an application from apex, but the buttons create, save and delete does not appear to work whenever I click on them. The edit option is enabled so I do not ...
user avatar
0 votes
0 answers
26 views

I keep getting an error on my sql code

I am working on a sql project and I keep getting this error: ORA-00923: FROM keyword not found where expected 00923. 00000 - "FROM keyword not found where expected" *Cause: *Action: Error ...
user avatar
1 vote
2 answers
71 views

db<>fiddle (Oracle): Query works in 18c, but not 21c

I have a Oracle query that I use to analyze the vertices of SDO_GEOMETRY polylines: WITH lines AS (SELECT SDO_UTIL.FROM_WKTGEOMETRY('MULTILINESTRING ((0 5 0, 10 10 10, 30 0 33.54),(50 10 33.54, 60 10 ...
user avatar
  • 1,373
-2 votes
2 answers
30 views

I have a table where where each project_id generates multiple rows

My table below shows the rows and columns where the column data is filtered using a CASE syntax to differentiate capital from expense. The problem is I am getting multiple rows per project_ID. I need ...
user avatar
  • 3
0 votes
1 answer
42 views

Is there any method like max() function? oracle version 11.1.0

I want to select the maximum value, but if the user has more than one value in one column, then leave all I have a table : create table package (U_id, service, offer,product) as select 1, 12345, ...
user avatar
0 votes
1 answer
22 views

A fast question about kerberos and Oracle

I'm configuring Kerberos on Oracle I have 2 machines, one is a server with Oracle DB, the other is a client with oracle client(basic+sqlplus), my sqlnet.ora is like this(on server) SQLNET....
user avatar
  • 183
0 votes
2 answers
34 views

Oracle: a litte confused about privileges granted to my user

I want to give few permission to my non-dba user on my database. I give create session, create table, view, etc.. This query seems to confirm SELECT privilege from USER_SYS_PRIVS; PRIVILEGE --...
user avatar
  • 183
0 votes
1 answer
22 views

Oracle 11gR2 - Expdp Full Database With Exclude Some Table Data

We will migrate our database using datapump. It will be full database export with exclude some table's datas. But we want to do a different operation for 2 different tables. We want to export the data ...
user avatar
0 votes
0 answers
35 views

During the trigger execution getting error : ORA-00604: error occurred at recursive SQL level 1 ORA-00900: invalid SQL statement

When I am trying to execute this trigger getting following error: CREATE OR REPLACE TRIGGER create_table_trigger AFTER CREATE ON SCHEMA DECLARE lv_sql VARCHAR2(5000); obj_name VARCHAR2(...
user avatar
-1 votes
1 answer
35 views

XTTS database migration AIX to Linux

I used Doc ID 2471245.1 for migration of 12.2 oracle database on AIX to same version to Linux x86_64, and on phase 5 while importing metadata , impdp fails with ora-39123 and ora-29342. Do you have ...
user avatar
0 votes
0 answers
29 views

Noaudit and Drop Audit Don't Work for Oracle 19c

I've enabled unified auditing at our production database (ver. 19.14). Created policies for auditing all dml's and select queries. After seeing that it's filling up SYSAUX table, i decided to disable ...
user avatar
0 votes
0 answers
169 views

Any information found for CVE-2022-22965 (Spring2Shell) for Oracle or SQL Server?

Any information found for CVE-2022-22965 (Spring2Shell) for Oracle or SQL Server? All quiet from their support organizations as of today.
user avatar
0 votes
1 answer
28 views

Query to update one column based on the amount of another column

I have a table with below structure : create table Z_TEST_ONE ( col_id NUMBER, bed_amnt NUMBER, bes_amnt NUMBER, bop NUMBER ) Sample data is like this : col_id bed_amnt ...
user avatar
  • 1,294
0 votes
1 answer
40 views

Oracle: I drop a table, but select still show it

I see today a strange thing on my oracle db. SQL> select tablespace_name, table_name from user_tables; TABLESPACE_NAME |TABLE_NAME ----------------------------...
user avatar
  • 183
0 votes
1 answer
38 views

understanding oracle pluggable databases

I'm learning a little bit about Oracle Database. As I understand: In previous versions of Oracle DB (versions <= 11ng), each DB should be installed in a separate server. Is this statement true? ...
user avatar
  • 103
1 vote
1 answer
34 views

In a string, replace third number in each set with new number

I have a string that has coordinates. Individual coordinates are separated by spaces. Vertices (X Y Z coordinates) are separated by commas. Vertex groups are wrapped in brackets and separated by ...
user avatar
  • 1,373
0 votes
1 answer
31 views

Oracle: sub select with AS, COALESCE, GROUP BY, HAVING CASE WHEN and ORDER BY

I am typing the below code and it is returning me "ORA-00923: FROM keyword not found where expected". What is happening? SELECT max(alias.id) AS "id", (SELECT ...
user avatar
0 votes
1 answer
38 views

Troubleshooting RMAN-03009: failure of delete command on d1 channel

I don't have many experience about RMAN backup. I'm running backup daily level 1 incremental backup and weekly Level 0 incremental. Backup files will kept at 2 difference locations (each location one ...
user avatar
  • 101
0 votes
1 answer
61 views

How to convert UTF8 data from PostgreSQL to AL32UTF8 Oracle DB?

I have a task to import some data from Postgres database to Oracle via dblink The connection between Postgres and Oracle works good, but unfortunately, when I try read data from created view (in ...
user avatar
  • 1
1 vote
1 answer
27 views

Get explain plan for query with inline function

I have a query that has an inline function: with function with_f(p_text in varchar2) return varchar2 is begin return p_text; end; select with_f(dummy) from dual Is there a way to get the ...
user avatar
  • 1,373
0 votes
0 answers
20 views

What is the difference between statement level and object level parallel hint for a select Statement

Does object level parallel hint affect the table settings for parallelism? Will statement level parallel hint apply to only that particular query and won't affect any default settings?
user avatar
-4 votes
1 answer
28 views

what is wrong with my query?

CREATE TABLE Match( MId INTEGER, TId INTEGER CONSTRAINT tid_fk REFERENCES Match(TId), Player1 INTEGER CONSTRAINT pl1_fk REFERENCES Match(Player1), Player2 INTEGER CONSTRAINT pl2_fk REFERENCES Match(...
user avatar
0 votes
1 answer
87 views

PDB Oracle DB ORA-40365

The essence of the problem is this. I'm trying to open pluggable database but it opens with Warning: PDB altered with errors. An error occurs in pdb_plug_in_violations (Sync PDB failed with ORA-40365 ...
user avatar
0 votes
0 answers
25 views

Optimizing a view query that uses pivot aggregation - Oracle

I have a table with columns as - | ID | cat_1 | cat_2 | type | value | |----|-------|-------|------|-------| |1 | a |b | t1 | 4 | |2 | b |d | t2 | 5 | |3 | b |e ...
user avatar
0 votes
0 answers
34 views

Are there performance issues with FKs on different schemas?

In order to perform functional decomposition of a "big blob" of a database the first step we wanted to take is to separate different modules of the database into separate schemas on the same ...
user avatar
0 votes
0 answers
27 views

Why should I backup vote file in Oracle?

I understand that vote file says what nodes are active in the cluster, like a "center of ping", and, if some node not send a message to vote file in 30 seconds, it's removed from cluster. ...
user avatar
  • 506
-3 votes
1 answer
43 views

Migration from Sybase to IBM-DB2 or Oracle?

We are planning to modernize our robust power builder /sybase application , that has around 500+ stored procedures,300+ tables. PB application produces 300+ reports,nothing but datawindows which has ...
user avatar

1
2 3 4 5
150