Skip to Main Content

Questions

QuestionUpdatedAsked

Hello,1. Could you please confirm if we can use REST API as DATASOURCE for RDF report, to generate the output ? Otherwise, what alternative can be done to store REST API data and then use it for RDF report ? Will Before-Report trigger come into play ?2. Prev...
5 minutes ago2 days ago

We have an overloaded stored procedure with the following declarations in our 3rd party application:<code>PROCEDURE GetPriceInfo (Location IN VARCHAR2, ProductCode IN VARCHAR2, SalePrice OUT NUMBER);PROCEDURE GetPriceInfo (Location IN VARCHAR2, ProductCode I...
21 minutes ago3 hours ago

Hi Tom,In an development Server we want to do a Rman Backup weekly which hasthe following tablespaces:SYSTEMSYSAUXUNDOTBS1TEMPUSERSIAGENT_DATAARCHIVE_MESSAGESI want to exclude the ARCHIVE_MESSAGES Tablespace in the weekly backup which has historical Data to sa...
27 minutes ago9 hours ago

Is there a report that will list the API's being called in a particular environment and their details?If not a report, is there somewhere in the UI? (Screenshots or path would be most appreciated).I don't know much about REST API's other than they are web serv...
36 minutes ago13 hours ago

Hi,I am using oracle 19c this feature does not work. I am trying to use auto increment feature in a existing table. Naturally i tried altering table for auto increment it doesn't work. The only way appears to be only in create table. We have to do this in prod...
40 minutes ago10 hours ago

I have just concluded a high level plan to migrate 10g oracle into 19c but will consolidate 2 databases into one standalone. (Non-CDB). In 10g the two database exists on separate host so one is an ARCHIVAL target for PROD...Periodical data export from PROD to ...
42 minutes ago18 hours ago

I'm currently running a daily backup asRUN { RECOVER COPY OF DATABASE WITH TAG 'IMAGE_COPY' UNTIL TIME 'SYSDATE-7'; BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'IMAGE_COPY' DATABASE; BACKUP DEVICE TYPE DISK TAG 'IMAGE_COPY' ARCHIVELOG ALL NOT BA...
55 minutes ago34 hours ago

hi tomcan u explain me in detail about "start with connect by" sql statement (tree structure).i know there is documentatin but it is very confusing. ...
21 hours ago21.5 years ago

hello tom,I hope you don't get angry now, if I "redirect" you to </code> http://asktom.oracle.com/pls/ask/f?p=4950:61:166184132340407832::::P61_ID:442119935770 <code>there is MY MOST important question. TODAY I've got your book - but unfortunately I haven't fo...
22 hours ago19.5 years ago

Hi Experts, Thanks for taking the time out to ready my Question. I am receiving a file from a third party as a flat file, with different lines of different lengths. The first two characters of each line represents what data that line will have. (Please let me ...
22 hours ago4.9 years ago

Hello,yesterday we recognized that one of our Applications runs very slow. After we did a little bit of researching, we found out that one of our Update-Statements takes significant longer than the day before. After looking into v$sql we saw that the beginning...
22 hours ago5.7 years ago

Hi Tom, This morning I saw an example on otn describing the sql with clause in 9i. I also saw an example, unfortunately that page seems to have been removed so cannot give you a reference. Here is the question though. How does a select statement with a inlin...
22 hours ago20.3 years ago

Team,was reading this post - https://blogs.oracle.com/datawarehousing/post/using-the-excel-add-in-to-query-autonomous-databaseand downloaded zip file (oracleplugin.zip) and ran the install.cmd file - but still don't see the My Add-ins in the insert tab from Ex...
22 hours ago8 days ago

Hi Ask Tom Team,Recently I came across MATCH_RECOGNIZE clause. I checked the Oracle documentation but it's not easy to digest.Looking at OLL webinars, youtube videos and some of Ketih's article on oracle blog helped me understanding a little of it.In oracle tr...
2 days ago5.6 years ago

Hi Team,i restored database to another server using RMAN backups and Archived logs, database restored fine, my question is i wanted to also restore data of unarchived online redolog files also ? how can i include unarchived online redolog files in recovery pro...
2 days ago7 days ago

How can we determine the correct number of licenses needed? We are attempting to estimate the licenses need for all our applications. Vertiv uses on premises eBS, and Cloud applications. ...
2 days ago7 days ago

Hi, when trying to create a local text index on an interval-partitioned table in Oracle DB v19c, we are getting an error.SQL:<code>CREATE INDEX TEXT_INDEX ON BOTS_CONVERSATION_UTTERANCE(UTTERANCE) INDEXTYPE IS CTXSYS.CONTEXT LOCALError report -ORA-29940: User-...
3 days ago7 days ago

Hi.I'm using Oracle Analytic Views (from 19c) as defined here: https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic-views.htmlI can create measures with simple aggregations (eg: SUM, COUNT, MIN), but I can't create a measure th...
3 days ago10 months ago

working with oracle sql and oracle service bus. I have a problem with closing the connection. An example of a simple procedure I use is the following :<code>create or replace procedure getempdata( v_id in number, q out sys_refcursor)asbegin open q for selec...
3 days ago7 days ago

How can i extract data from flat file to oracle table with plsql ? ...
3 days ago22.4 years ago