I would like to create a table in an Oracle 19c DB (on premise) that is optimally designed for many parallel DML queries (INSERT/UPDATE).What do I have to pay attention to?Does partitioning help, with different tablespaces?How must sequences be created or shou... | 17 minutes ago | 10 days ago |
Dear TomI cannot create an index on a virtual column of type RAW or RAW(30). I've used virtual columns several times in the past and I also indexed them, with no issues so far. This this the first attempt to do so with a RAW column, but I fail.Why do I want to... | 19 minutes ago | 32 hours ago |
I have a simple table with numeric column<code>create table foo (i integer);/</code>In my apex application I have a very simple automation(scheduled, always, daily at midnight) and my action code is:<code>begin insert into foo values (1); commit; exec... | 20 minutes ago | 3 days ago |
I have the following query. I am wondering why, oracle sufixes "000" with the given timestamp value when I format it. SQL> alter session set NLS_TIMESTAMP_TZ_FORMAT='dd/mm/yyyy hh24:mi.ssxff' ;SQL> alter session set nls_timestamp_format='dd/mm/yyyy hh24:mi.ssx... | 8 hours ago | 23 years ago |
HiWe are looking to take a schema(abc) from our database to to a different server with a new schema name.I am looking to find what are the dependencies on the abc schema in our packages/procedure/functionsand is there anything else i should be looking at.regar... | 14 hours ago | 5 days ago |
Hello Connor/Chris,Hope you are doing well.I came across MOS note ORA-6502 Research Events (Doc ID 2911572.1), which claims to recommend an option to enable trace to get more details about ORA-06502 error.However, I am not able to reproduce the behaviour on 19... | 19 hours ago | 5 days ago |
Using Oracle RDBMS 19.19APEX 24.2.2ORDS 24.4.0.r3451601Goal: Create an application container to contain APEX and ORDSIssue: One of the install steps fail, and I am not able to get rid of the application in "installing" status. I have tried Doing a <code>ALTE... | 19 hours ago | 4 days ago |
I have a ddl trigger (after ddl on database) for analyzing package (spec) source code. It works perfectly if i write the whole command, like<code>create or replace package xyz as procedure foo; end;/</code>I can then pick the source code inside my trigger by s... | 20 hours ago | 3 days ago |
Hi Tom,This is a DDL question/observation, which puzzles me a bit:Given the following succesfull creation of a table in a schema PL, on Oracle 19c:<code>create table pl.constraint_test( id integer, end_date date, constraint end_date_not_null check (end_date is... | 22 hours ago | 3 days ago |
how can i insert and read numeric value larger than 1000 digits into blob column in oracle... | 22 hours ago | 2 weeks ago |
Hi TOM,Sorry for asking this basic question (After two hours of searching, I am unable to find the answer)Let's say I have run opatch in an ora19 home to patch the binaries.But then I "forgot" to run datapatch.Is there any dictionary view to tell me that I "fo... | 22 hours ago | 9 months ago |
Hi,I have a column in table that have yet text in fields. Some of fields have in the end of text: distance: R1: a R2: b R3: c mm mm mmI want to insert before the first mm d/a, the second mm d/b and the third mm d/c. It will be : distance R1: a R2: b R3: c d/a ... | 3 days ago | 12 days ago |
I need to union two database querieres for an export job.Any idea how this is formatted on a par file?... | 3 days ago | 5 days ago |
here is the test.<code>create table t1(id int, name char(10));create table t2(id int, name char(12));insert into t1 values(100, 'yang');insert into t2 values(200, 'yang');commit;-- return 1 rowselect * from t1, t2 where t1.name = t2.name and t1.name = 'yang';-... | 4 days ago | 6 days ago |
So I am able work out partition by reference with the DDL below, but can seem to figure out how to also get IOT too. The examples with IOT I have seen needed the PK defined in the create table DDL. Since my solution for making the PK on the child table with ... | 5 days ago | 6 days ago |
Greetings,How does the data structure of a compound index in Oracle look like? I'm wondering how Oracle is able to use a "skip scan" by using the second entry in a compound index? I know that the first field uses a b-tree structure, but I am unsure how the s... | 7 days ago | 2 weeks ago |
I am working on a Business SaaS solution and my data is siloed using a tenant_id column. I am setting up REST APIs using ORDS (v24). The application will provide the ability to POST and GET the subscribers data. Each subscriber will be provided their own se... | 7 days ago | 6 weeks ago |
Hi Tom, I have a question regarding to add some constraint into a table.I have 2 tables defined as:<code>create table TableA ( fieldA varchar2(10), fieldB varchar2(10), fieldC varchar2(5), fieldD varchar2(10) not null, fieldE number(38) not null, Con... | 10 days ago | 10 days ago |
Hi Tom,I am trying to alter the tablespace to the transportation tablspace. First I do: alter tablespace users read only;Then do :exp sys/change_on_install file=02072001.dmp transport_tablespace=y tablespaces=users triggers=n constraints=nBut I got the error a... | 10 days ago | 24 years ago |
Hi,I have read quite a bit on Oracles RMAN utility and know that for hot backups RMAN doesn't use old method of placing tablespaces in Archive log mode freezing datafile headers & writing changes to Redo/ Archive logs. Hence a company with a large DB shouldn't... | 10 days ago | 22.7 years ago |