Skip to Main Content

Questions

QuestionUpdatedAsked

connect system password : password. i got following errorsORA-01034: ORACLE NOT AVAILABLEORA-27101: shared memory realm does not exist...
16 hours ago6.8 years ago

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...
4 days ago9 days ago

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...
4 days ago11 days ago

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...
4 days ago12 days ago

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...
4 days ago2 weeks ago

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...
5 days ago11.5 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...
5 days ago8 months ago

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...
5 days ago6.7 years ago

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...
6 days ago11 days ago

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...
7 days ago10 days ago

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...
8 days ago11 days ago

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...
8 days ago11 days ago

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...
8 days ago12 days ago

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...
8 days ago3.2 years ago

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 ...
8 days ago2 weeks ago

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?...
8 days ago2 weeks ago

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...
8 days ago2 years ago

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...
11 days ago2 weeks ago

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...
12 days ago2.2 years ago

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