Skip to Main Content

Questions

QuestionUpdatedAsked

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...
5 hours ago2 days ago

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 ...
5 hours ago18.5 years ago

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....
5 hours ago5.1 years ago

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....
27 hours ago4.8 years ago

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

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

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...
2 days ago13 days ago

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...
4 days ago4.1 years ago

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

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

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

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

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

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

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...
9 days ago1.6 years ago

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

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

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...
12 days ago20.3 years ago

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...
12 days ago5.1 years ago

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