Questions

Hi guys,I have a little question on how does B2B data sharing work ?Say I am the department of home affairs and I want to share the data I hold (data that lives into an Oracle db) to others departments of the country.Especially the data about HR.So how to do w...

Hi Tom, Some questions about the SQL tuning. 1) I found that when using "IN" in the where clause , INLIST ITERATOR is shown on the explain plan in a cost-based database (and using the index correctly, the response is fast). However, no such INLIST ITERATOR ...

how to download a free oracle magazine in pdf about getting latest oracle database and it's technology relevant information as like MSDN of microsoft....

Hi,I know how to use transform=oid:n in a CMD box using impdp. Is there a way to add that parameter to the import when using the Datapump Import Wizard in SQL Developer?Thanks....

Hi all,It's first time post.We are facing a problem in 19c when generating a csv file.In 12c, results were as expected.Spaces are added after or before the content of the column.Please find attached the information about the environment.-- tables structureColu...

Hi Tom and Team,I have a SELECT query that runs fine if submitted the 1st time (takes about 3 seconds), but if I submit it right after again, it could take anywhere from 22 to 37 seconds (on a pretty consistent basis). If I wait a few hours (or if I issue the...

Hi TomWant to understand how and where memory is allocated in an instance to evaluate decode, regexp functions in oracle? If we are reading data from a table and writing it any other location(not oracle), then what would be better-->while firing the query wit...

I have a table with 100 million rows. Table size is around 25 GB in the DB.I need to unload this data to a csv file.What is the best fastest way to do this.I was reading about external tables to do this by using CTAS but I dont think there is an option to dire...

Hello, Ask Tom Team.I want to do pagination in a report connected to an Oracle 18c database. I have read there are some methods to do the pagination like: offset and seek. I have several questions1. What method is the best? I have heard that OFFSET methods can...

Hi Tom,We have a query which has to get a set of rows over the db link which has a CONTAINS predicate on a column of CLOB.E.g.There is a DB A and DB B with table T1( c1 varchar2(10),c2 clob) .I want to run a query from DB A using dblink on DB B to query T1 whi...

I have a sqlldr control file that looks like this name char(255) enclosed by '"',contactemail char(255) enclosed by '"',rawtext1 filler enclosed by '"',rawtext2 filler enclosed by '"',auditdate char(255) enclosed by ...

Hi,I am trying to load a data file into a database table using SQL loader. I received the data in an Excel spreadsheet but I saved it as a comma delimited file.When I run the SQL Loader command no records are loaded - looking at the log file I get the followin...

I read the article, titled:<b>Event Monitor Process: Architecture and Known Issues (Doc ID 105067.1)</b>…Notification implements a high-watermark scheme where when the backlog of notification events hit an in-memory limit the messages are, in the case of 9.2, ...

Hi,I'm trying to consume Oracle fusion rest web service's in PLSQL using apex_web_service. I'm getting the below error. could you please guide me on this.also Pls suggest how to enable the basic authentication in web service like how to set the basic auth.ORA-...

Hello!Thanks for answering my questions regarding the testing of Oracle SE2's CPU thread limit on Oracle 11g Standard Edition - I really appreciate the informative response.I have a related question...If we have a server with, say, 18 CPUs hosting 4 SE2 single...

Dear Tom,about two weeks ago we moved a test database from 12.2.0.1 SE2 to 18c XE via data pump. We used schema import into a pdb with compression enabled (from the parameter file: TRANSFORM=TABLE_COMPRESSION_CLAUSE:"ROW STORE COMPRESS ADVANCED"). There is no ...

Hi Tom,Just want to ask is there any difference between doing objects(tables,indexes and etc) reorganization within same tablespace and to new tablepsace? Normally i used to do reorganization to another tablespace but this method will need extra space to move ...

Hi Tom,Here are the few questions on Locking. 1)How do I use v$lock to figure out lock details ? Details likewhos has locked,on which table,who else is waiting, and what typeof locking (shared or exlusive ?), since when it is locked.2)Why and when exclusive/sh...

Hello,I am attempting to delete a record / object (that may use several tables at the DB level) from an application.The delete statement is raising aORA-02292: integrity constraint <constraint name> violatedHow can I find the Delete statement (DML) being execu...

Is there a way to update all listeners to a new OHome after upgrade? Going in manually to each listener (say 10) to update the new OHome seems like there should be an easier way but I'm unable to locate anything on it....