Questions

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...

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...

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...

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...

Hi Team,I use ApEx 22.1 and SQL Developer.In an ApEx page, users have to upload 4 photos of their workstation. Then with PL/PDF I generate the PDF containing texts, photos and ID number.I have no control over the uploaded photos. The aspect ratio of the images...

We are going to MOVE the TBS of AUD$ table in PROD. Purpose:AUD$ table is totally fragmented and the CLEANUP / PURGE runs very slow - even with max 1.000.000 batch size but as per test in our test environment we had some issues regarding using API (DBMS_AUDIT_...

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...

Dear Ask Tom Team,can you suggest me the best way to have my "<b>datamarts</b>" tables, that summarized data(coming from the <b>oltp </b>database) using <b>analytical functions</b>,daily refreshed?ThanksAlessandra...

how can i insert and read numeric value larger than 1000 digits into blob column in oracle...

i have 1st table MIT_DOCUMENTS_LIST_MASTER with columns and data<code>ID DOCUMENTS_LIST1 Passport Copy2 Visa Application Form3 Company Cover Letter4 Invitation Letter</code>second table VISA_ON_ARRIVAL_COUNTRIES columns and data<code>id COUNTRY_ID COUNT...

Hello,I accidentally dropped an index on a table (Oracle 19c) that was constructed on three columns; one of them was a foreign key.table: INDEX_DEFINITION:<code>CREATE INDEX "dba"."INDEX_SOP" ON "dba"."USR_SOP_STD" ("TS_ID", "TS_ASSET_SUBDOMAIN", "TS_TITLE") ...

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...

Oracle provides an initialization method that will automatically run when the package is first accessed within a session. My question, is there a method that gets called when the session ends?The reason I am asking this is because I have a package that connec...

Hello Tom,What is the practical implementation of Instead of Triggers in the application? Can you provide some practical examples?...

Hi Tom,I'm trying to get rid of a performance problem in APEX with a pipelined function within an db-package. Reading ora-documentations and searching the web/comunnities wasn't successful. Sorry if my question is already answered - i haven't found it.My situa...

I completed the course Database for developers foundation. I did not recieve an email of the certofocate but i did have the option to print the certoificate. but I want to have a URL that can show as proof of creidentials. where to get it? Please help I invest...

Hello All,I have a PL/SQL function that takes two INTERVAL DAY TO SECOND parameters and returns a value of the same data type.It works correctly as a regular PL/SQL function.I try to convert it to an equivalent SQL MACRO, both as a TABLE (in 19c and 23ai ) and...

Starting with 21c (and continued in 23ai) I've noticed that Oracle database does not "automatically sort" data when working with set operators such as UNION, MINUS, INTERSECT etc, while it used to sort data till 19c. Is this behavioral change documented somewh...

Hi Tom, I am practising Recovery . CASE 1)I have Development TEST DB in NON-ARCHIVE Mode. NEVER backed up. All Redo log files including the active one ,are dropped from the OS. How to recover such a DB. I dont mind loosing Transactions. Is it possible ?C...

I got a requirement to capture user login logout timestamp of database in any method like login via application, Sql development tool or any source. the purpose is to track all user login/logout information of database.We tried with logon and log off trigger b...