Skip to Main Content

Questions

QuestionUpdatedAsked

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 ago10 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 ago32 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 ago3 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 ago23 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 ago5 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 ago5 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 ago4 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 ago3 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 ago3 days ago

how can i insert and read numeric value larger than 1000 digits into blob column in oracle...
22 hours ago2 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 ago9 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 ago12 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 ago5 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 ago6 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 ago6 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 ago2 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 ago6 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 ago10 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 ago24 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 ago22.7 years ago