Skip to Main Content

Questions

QuestionUpdatedAsked

We recently had a database failure that resulted in data loss after an Oracle 19.3.0.0.0 database had both both its control, and redo log files deleted. Please note that I am not a DBA, but simply an analyst that supports the system that sits on this Oracle da...
3 days ago6 days ago

Is 'SELECT * FROM :TABLE_NAME;' available?...
5 days ago7 days ago

Hello Sir,I am able to get one scenario to work and that scenario was where I had a VM (server) running Oracle 19c with just 1 table 5 records and I did a backup of the whole VM (disk backup) and now I added a new table in my db with 3 records (ensured db is ...
6 days ago8 days ago

We have an application that has been written to insert a variable that is char(50) into a column that is defined as char(40). In Oracle 11g (I know this is very old) it would merely truncate the last 10 characters without issue. However, Oracle 19c doesn't a...
6 days ago2 weeks ago

According to https://docs.oracle.com/database/121/SQLRF/functions100.htm#SQLRF00658 the length function should work on a clob and on a varchar2, returning the length of a string in characters, as defined by the input character set.Could you explain why the len...
6 days ago2.4 years ago

Hello,I wanted to ask about new 23C feature - Schema-level Privileges: is it possible to combine it with "WITH GRANT OPTION"?According to documentation https://docs.oracle.com/en/database/oracle/oracle-database/23/dbseg/configuring-privilege-and-role-authoriza...
7 days ago7 months ago

Hai all,I have 1000 number of tables. some of the tables got delete rows and updated the fragmentaion is created.How to determine which tables are fragmented ?...
7 days ago8.2 years ago

Hi TeamI have below scenario.Step#1) User clicks to particular App UI screen.Step#2) User selects multiple filters on UI - say filter1, filter2 which correspond to table columns.Step#3) For each filter selected by user, he needs to enter data - say Mark (for f...
7 days ago8 days ago

I am migrating 11g database cross endianness from on-prem to EXACS . On-prem database db_block_size is 4k and all the tablespaces are also of 4k block size . <u>Since, I cannot provision non-standard block size database in OCI</u> , I am worried about the per...
7 days ago9 days ago

How to connect oracle database / data set into Power BI, I already searched from google and youtube but I can't do it please help.Thank you....
11 days ago2 weeks ago

Hi,We are trying to compile following class in Oracle database 23c. However, we are encountering surprising error (we are not using ANY database link:Error report -ORA-04054: database link MYOPTIMIUM does not exist04054. 00000 - "database link %s does not exi...
11 days ago12 days 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....
11 days ago7.4 years ago

Hi Tom,Can you explain, what is 'EDITION' and what is it meant as cross-edition triggers? How it can be useful for high availability.Thanks for you replies. It is a big learning experience....
13 days ago14.5 years ago

Hi,What has happened to Tom Kyte's blog http://tkyte.blogspot.com/.Can you add me to white list of that blog ? Will be very great-full.ThanksFahd...
13 days ago6.6 years ago

Tom,DBA.DBLINKS - I am confused about what's in DBA_LINKS - I have never used them. I just want to understand what the column definitions mean. They are too vague.OWNER - The user who created the database link. If the link is public, then the user is listed as...
13 days ago7.1 years ago

Hello, I am an intermediate SQL and PL/SQL user and I am interested in becoming an Oracle Database Administrator. Could you provide me with a roadmap or step-by-step guide on how to become an Oracle DBA? Additionally, I would appreciate any recommendations on ...
13 days ago1 years ago

We just hit 2.1 billion row count on a table with primary key INT. This is the worse thing to happen :( Any one know if we can do alter without requiring space on the DB for the entire table?...
13 days ago8.5 years ago

Hi, I'm interesting to know if there is any way to execute external procedures in Autonomous database cloud service?Actually we use external procedures calls to execute important routines (functions) needed for our applications, we are using Linux and Windows...
2 weeks ago1.5 years ago

We have seen in many situations in our environment where a SQL was running badly but the plan for the query has not changed. When we gather stats for the associated table.we see that same query performs significantly better. However there is no change in PHV o...
2 weeks ago3 weeks ago

Hi Tom, I went through the articles & documentation, your article answers most of the issues Asktom EBR Part 1 => http://www.oracle.com/technetwork/issue-archive/2010/10-jan/o10asktom-172777.htmlAsktom EBR Part 2 => http://www.oracle.com/technetwork/issue-arch...
2 weeks ago7.9 years ago