Skip to Main Content

Questions

QuestionUpdatedAsked

Hello,I am trying to find out the best way to include a criteria in a sql to check is the latest event for a user has occurred before a specific date.Below is my table setup and brief descriptionUSER_NP => Parent table listing all users (in origina...
113 minutes ago37 hours ago

Hi Team,We are facing issue while using Between function in our SQL query. We are trying to use Between function on a column which is of datatype VARCHAR2. Data insert in this column can be alphanumeric as well as numeric, But it seems this function is not wor...
13 hours ago13 hours ago

I was trying to understand how redo works in nologging mode. Here is a interesting situation i encountered in XE.<code>SQL> @redo_question.sqlTable dropped.Table created.LOG_MODE------------NOARCHIVELOGStatistics------------------------------------------------...
21 hours ago29 hours ago

Hi From the past I am only aware of Tom Kyte's Runstats package, which allows comparing some performance metrics across two procedures. I also found that the DBMS_SQLPA package also provides a feature that could help in this kind of scenario.For example once y...
22 hours ago25 hours ago

Hi,We've near to 6 million records in our database and we want to update one specific column value for all the records.query will be like this: update table_xx set column_xx = '' where column_xxx = '';Is there any limitation in Oracle DB? If we run this query ...
22 hours ago33 hours ago

Hello,I know we can use BULK COLLECT to load all the records from a cursor into a set of collection variables, plus we can also use LIMIT clause to set the max number of records per load. It would be very convenient if Oracle can support the feature of BULK CO...
22 hours ago30 hours ago

Our DB version is 18.3.0.0.We want to set a Global Temporary tablespace at CDB level and drop the Temporary tablespace at the PDB level.1. The DEFAULT_TEMP_TABLESPACE is set in root container.2. While in the Pluggable, when trying to drop the temporary tablesp...
22 hours ago30 hours ago

HelloWe have a Oracle 11g Release 2 database with five identical working Schemas being accessed by a VB Client Server business applicationThe db server, with 32GB RAM just hosts this one databaseCopies of Client applications are installed across RDP Servers Tw...
22 hours ago12 days ago

using DBA_ROLE_PRIVS and DBA_USERS, how can i determine users with DBA role (also hidden role) ...
31 hours ago38 hours ago

Hi Team , I have table named "CALL_LOGG" with ~1M record's , table is partitioned with range-hash we have index in one of column named as logdate which is having date datatype .most of time i see query using major filter as logdate is unable to make use of...
32 hours ago39 hours ago

Hi Team , I am trying to create test scenario where the table name TEST is created with 1 column ID.<code> Name Null? Type -------------------------...
32 hours ago39 hours ago

Hello Team,We have to extract huge data from EBS tables. We have tried two approachesApproach1 (Using SQL and Spool command)---------We have created a script to generate the output using SPOOL command but this is taking 12 hours of timeApproach2 (Using Cursor,...
37 hours ago1.1 years ago

hello,i use ' dbca -silent -createTemplateFromDB -sourceDB host:port:sid -templateName sidbak -sysDBAUserName xxxxxx -sysDBAPassword xxxxxx' to generate template file,for example,[oracle@orcl13 ~]$ dbca -silent -createTemplateFromDB -sourceDB orcl13:1521:orcl1...
39 hours ago2.5 years ago

Hi,I'm using a database that is mostly case insensitive, using this login trigger:<code>create trigger milenio_central_logon after logon on milenio_central.schemabeginexecute immediate 'alter session set NLS_COMP=LINGUISTIC';execute immediate 'alter session se...
39 hours ago4.3 years ago

In a database with character sets defined as:NLS_CHARACTERSET = AL32UTF8NLS_NCHAR_CHARACTERSET = UTF8Would there be any difference in the (language) character sets that could be stored by VARCHAR2 Vs. NVARCHAR2? As inNAME VARCHAR2(60 CHAR)Vs.NAME NVARCH...
40 hours ago4.5 years ago

Hello Tom, How to do a Full DB exp and Import.I do say exp system/manager@xyz FULL=Y FILE=FULL.DMPThen If I want to do a full Import to a new freshly created DB which only has the default schemas sys , system , etc.1) Please correct me :- I would n...
40 hours ago11.1 years ago

HI ALl,say what is the url to the ppt for:“BCS Office Hours - Multitenant Fundamentals & Hands On Lab” ?/thanks/paul...
40 hours ago6 days ago

The following shows that the same (JSON) table data and the same queries yield different results when different NLS_NUMERIC_CHARACTERS are used.The above sentence is no surprise, obviously, but in this case I consider the behavior to be wrong; Please explain w...
40 hours ago3.5 years ago

I have a oracle 12c installation.Following commands were executed as SYS user.ALTER SYSTEM SET MEMORY_MAX_TARGET=20G SCOPE=SPFILE;ALTER SYSTEM SET MEMORY_TARGET = 20G SCOPE = SPFILE;ALTER SYSTEM SET PGA_AGGREGATE_LIMIT = 15G SCOPE = SPFILE;ALTER SYSTEM SET PGA...
40 hours ago2.9 years ago

I just want to exp and imp,but when I imp the dmp file to another database,the failer message occured below:ORA-14692: STORE AS clause is not allowed for extended character type column.what should I do?...
40 hours ago10 months ago