connect system password : password. i got following errorsORA-01034: ORACLE NOT AVAILABLEORA-27101: shared memory realm does not exist... | 16 hours ago | 6.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 ago | 9 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 ago | 11 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 ago | 12 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 ago | 2 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 ago | 11.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 ago | 8 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 ago | 6.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 ago | 11 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 ago | 10 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 ago | 11 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 ago | 11 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 ago | 12 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 ago | 3.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 ago | 2 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 ago | 2 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 ago | 2 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 ago | 2 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 ago | 2.2 years ago |
Does oracle apex 23.1 data load wizard support excel files like the data loader in the SQL Workshop?... | 12 days ago | 13 days ago |