Questions

connect system password : password. i got following errorsORA-01034: ORACLE NOT AVAILABLEORA-27101: shared memory realm does not exist...

SQL-Profile fundamentally are additional optimizer statistics at the SQL statement level generated by SQL-Tuning-Advisor to fill the gaps of Oracle Optimizer.My question is, can these additional finer optimizer-statistics within profiles, be shared/used by ot...

Hi, Tom, I do two tests about cursor in ORACLE 19.3C. In test1 why print "x" is normal but print "y" is abnormal ? In test2 why print "y" run half of the way ? I get information from: https://asktom.oracle.com/pls/apex/asktom.search?tag=ora-08103object-no-long...

Hello,How to configure TLS for connections from Oracle database to another server (e.g mailing server)?We have an on premises SMTP email sever to which the database pushes the emails to be sent out. All internal emails are working perfectly but external email...

We have a system in which reference data (about 100 tables) is created and maintained by a set SMEs in a specific database for this purpose. On frequent (by not regular) occasions, the schema is cloned to another schema which acts as a source for distribution...

Is there a way to generate an alphabetical iterator like the column headings in a spreadsheet? i.e. A...Z and then AA,AB,AC,...,AZ,BA,BB,BC,...,BZ and so on.Googling leads to http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-programming/73630/Generating-alph...

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

I want to enable full SYS Context for tables in the Flashback Data Archive but I am concerned about space usage in the SYSTEM tablespace <code>exec dbms_flashback_archive.set_context_level(level => 'ALL'); </code>Can I move SYS_FBA_CONTEXT_AUD into a different...

Hi,I would like to create initally deferred constraint for FK as below. The problem is, that the constraint cars_service_car_id_fk is validated after DELETE statement, not at the end of transaction(COMMIT). I don't understand this behavior...<code>DROP TABLE c...

I would like my schema to delete rows automatically after a certain number of days.Therefore, I was planning to use this statement for example:<code>ALTER TABLE MY_TABLE USING TTL 5 days</code>However, I'm unable to find specifics in the TTL documentation abou...

Hola! en Apex 23.1Estoy fallando al intentar ejecutar un método GET luego de crear desde Componentes Compartidos >> Orígenes de Datos una conexión a un servicio web http (no seguro) público.El método GET lo pruebo desde la opción de edición. Y lo he probado ta...

I will preface this with not having had tested SQL*Plus scripts on Windows utilizing script arguments in a number of years so I can't categorically state when this stopped working on said platform. That being said, the issue described does not occur on any *n...

I am facing issue of "Pooled connection request timed out" when I upgraded database to 19c and moved the application to cloud(TAS) from VM.There is no fixed scenario when this happens. No code changes has been done except replacing DataAccess.dll to ManagedDat...

Hi ,I am unable to connect to oracle database using SQL DEVELOPER. It gives me" i/o error network adapter could not establish connection". Please let me know what are the possible reasons for it and provide me the solution for the same.- I am using sql develop...

Hi, I have column having data like below. 101010102030402030405060 etcFrom each row above I have to break as below to check whether that number exist in a table or not, if yes skip and if no then insert. E.g. for first row 101010First I have extract two digit ...

How to create a user for eBusiness DB account equivalent to APPS user but only with select and execute on FND, INV and APPLSYS objects?...

Hello Chris/Connor,I am trying to use the option MY_WALLET_DIRECTORY in TNSNAMES file in order to avoid having to specify WALLET_LOCATION in SQLNET.ORA file. However, it fails with ORA-01017: invalid username/password; logon denied error. Tracing the SQLNET (f...

I have the following query:select OPERATION_CODE, to_char(OPERATION_DATE, 'dd/mm/yyyy hh24:mi:ss') as OPERATION_DATE, EMP_CODEfrom HR_ORIGINAL_ATTENDANCEwhere EMP_CODE = 4415and to_char(OPERATION_DATE, 'yyyymmdd') = 20230517order by OPERATION_DATE;And I have t...

Hi Tom,I am trying to extract multiple hostname out from a long strings (In fact, I will use this method for DBLink - host column later). However, my query is only able to extract the first hostname. I did try to put {1,0} after the match pattern '((HOST|HOST...

Does oracle apex 23.1 data load wizard support excel files like the data loader in the SQL Workshop?...