Skip to Main Content

Questions

QuestionUpdatedAsked

Hi, Tom1.I always use dbms_utility.analyze_statistic('USER','COMPUTE') to create statistics for users schema. Is it creates statistics only for tables or for tables and indexes?Should I use ...(user,'COMPUTE','for all indexes') to compute statistics for indexe...
11 hours ago20 years ago

Hi :)!I have a database @dblink and I need to copy files with BLOB from @dblink to my staging database.What can I do?I can't CREATE tables because of restrictions, so we only should use TRUNCATE, UPDATE and INSERT.Thank you so much in advance!...
14 hours ago3 days ago

I would need to replace the chr(10) or chr(13) from the string. However i would need to exclude those chr(10) or chr(13) in middle of the string.eg:(2S,4R)-1-{1-[(2-acetamido-2-deoxy-ß-D-[(3-{5-[(2-acetamido-2-deoxy-ß-Dgalactopyranosyl)oxy]pentanamido}5,11,1...
14 hours ago2 days ago

Is there a way to create a pdf in memory and save it in a blob?We don’t want to create a database directory and create the actual pdf on the server. So, I am looking for a way to create it in memory and insert it into a blob field using pl/sql or a database p...
14 hours ago3 days ago

Hello, I created a Flashback Data Archive and gave it a retention of one year. Now I have enabled flashback archive for a test table. My problem is that minvalue does not work as I expected. My expectation is that the specified query will return ALL values tha...
15 hours ago3 days ago

Fix TextRemove any demonstration and sample databases, database applications, objects, and files from the DBMS.To remove an account and all objects owned by that account (using BI as an example):DROP USER BI CASCADE;To remove objects without removing their own...
15 hours ago3 days ago

Hi Ask Tom team,Do you have any information that CloneDB is not working anymore in 18c or 19c.I already have MOS-SR (SR 3-25408180791) open since march this year. First without any additional answers they told me that this is a bug (BUG 32087287 - ORA-17515...
16 hours ago2 months 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-...
16 hours ago2 weeks ago

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...
35 hours ago3 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 ...
35 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....
35 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....
2 days 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...
3 days ago3 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...
3 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...
3 days ago2 weeks 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...
6 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...
7 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...
8 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 ...
9 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...
9 days ago20.2 years ago