Skip to Main Content

Questions

QuestionUpdatedAsked

Hi Tom,I have a requirement to update/Delete(permanent) the archived(Data deleted. But present in flashback archive) data.Can we update/delete(permanently) a record/set of records present in flashback archive?...
45 hours ago7.1 years ago

Is there any SQL construct that does fuzzy matching ?As an example , if I have the values as Monroe , Monroe Twp , Monroe Township , "Monroe Twp,NJ" , I would like to consider them as one value . ...
46 hours ago6.6 years ago

Hi Tom , We have to load some data in oracle from a flat file . The date in flat file is displayed in Julian date format so 31st Mar 2003 comes as 2003090(number of days since Jan 1st,2003) and 20th Mar 2003 comes as 2003069(again number of days since...
46 hours ago21.2 years ago

Dear AskTom Team,I'm getting crazy wondering why a query with a FIXED baseline runs only sometimes with plan fixed by the baseline.<code>SQL_HANDLE LAST_EXEC FIX REP CREATED------------------------------ -------- --- --- --------SQL_1a03d3b...
3 days ago9 days ago

I've installed Microsoft's ODBC driver and configured various files in an attempt to create an ODBC connection from my Oracle database to SQL server, but I'm having trouble connecting from SQL Developer. Using the terminal, I can connect to the SQL Server succ...
4 days ago4 days ago

Hello, I am trying to figure out why this answer is correct regarding a LONG data type.Here is the questionEMP_DETAILS table<code>Name NULL TYPEEMP_ID NOT NULL NUMBEREMP_NAME NOT NULL VARCHAR2(40)EMP_IMAGE LONG</code>...
5 days ago5 days ago

Hi Chirs/Connor,Couple of question related to Table data movement from Primary DB to Archival DB.We are having Two DB's - Primary (holding current 2 years of data) Archival (Primary data + historical)We have separate Archival DB using IMP/EXP from Primar...
5 days ago7.4 years ago

I have a huge partitioned table(about 3TB) that has a constraint(PK) in "enable novalidate" state.I have to alter the state to "enable validate" state.<code>alter table TEST enable validate constraint PK_TEST;</code>The table belongs to the database(exa) in pr...
5 days ago9 days ago

Hi Tom,Need your kind help to check and advise. i need to find number of hours employee worked between 10:00 PM to next day 06:00 AM between two days.Ex: 1. employee work schedule is 11-MAY-2012 16:00:00 to 12-MAY-2012 09:00:00 Ans: Night hours would be 8 hour...
5 days ago11 days ago

I have a case where RR date format is not returning expected result... to_date('960504','rrmmdd') returns 2096, not 1996.I seem to recall back in Y2k an inti parm that influenced the action of the RR format.... but I can't find it. Am I imagining this?...
9 days ago6.8 years ago

Hi,Can we create Composite sub-partitions on multiple columns using templateExampleCREATE TABLE sgs.part_test( order_date_time SYSTIMESTAMP, modulo_store_id NUMBER, recurring_flag CHAR (1))PARTITION BY RANGE (order_date_time) INTERVAL ( NUMTOYMI...
9 days ago6.8 years ago

Hi Tom,We are creating a table that will be loaded daily. We want to partition the table by as of date. Is the best practice to create the partition using the partition by list automatic or partition by range using 1 day interval? Does one option give better p...
9 days ago2.2 years ago

I have been using AQ, and now I am trying to utilize Sharded queues in 19c. I am trying to understand some basics. I want to have single-consumer queues, and upon dequeue the record should be removed from the queue table. In the AQ (classic queues) it used to ...
9 days ago11 days ago

Hello TomWe have a windows server with 40 CPU with 10 sockets and 96 GB RAM and this server CPU keeps hitting 100 perc whenever application team runs there load and the number is session also gets very high . When we check we find many of there queries showing...
10 days ago11 days ago

Hey Tom,While this isn't a technical question, I hope it finds its place in this forum.I'm looking to sit for the 170-071 (Oracle Database SQL Certified Associate) exam as a complete beginner. I have a broad understanding of what a database is and its use case...
10 days ago11 days ago

I want to validate the clob column from the source table using db link, but I am not able to fetch the clob column from the source table via db link. I am not having any permissions to the source db(create view/create table/PLSQL execution) other than read acc...
10 days ago12 days ago

Tom,What is the difference between Checkpoint, incremental checkpoint & rolling checkpoints? I've read that an incremental checkpoint occurs every 3 seconds as opposed to a checkpoint which occurs based on fast_start_mttr_target, log switches, instance shutd...
10 days ago20 years ago

Is it possible to use array as a procedure parameter? ...
10 days ago10 days ago

Hi Tom,When I was using 10g EM to clone an instance, it restricted me to creating database name and sid to be larger than 8 characters. The oracle is installed in NT. Is there a way to bypass the restriction? Thanks a lot.Regards,Keane...
10 days ago17.5 years ago

We are using DB v19.0 with the latest patches. We are in Greece but our packages / procedures and client apps are designent to work on AMERICA NLS_TERRITORY, so everything works fine!But in some cases, some 3rd party apps, are connecting to our database using ...
11 days ago11 days ago