Tom Kyte

Subscribe to Tom Kyte feed Tom Kyte
These are the most recently asked questions on Ask Tom
Updated: 2 hours 5 min ago

Tables with no tablespace

Mon, 2018-01-22 20:46
Hi Tom, This may sound a little silly question but have not come across such situation yet. I have few tables create by user (not owned by sys or system) which do not have tablespace name. The following query returns table names. select ...
Categories: DBA Blogs

ORA-14300 on Interval partition

Mon, 2018-01-22 20:46
Team, We have an application, where we receive a set of files to be processed by application in 24/7. Each time a file recieves we generate a file_key in master_table using sequence, and take that file_key to load the file contents into this tab...
Categories: DBA Blogs

SQL*Loader-510: Physical record size limit

Mon, 2018-01-22 20:46
Dear Tom, I tried to load a text file to Oracle db using SQL*Loader. Here is the table definition: create table mytable ( key varchar2(40), adate date, atag number(10), aclob clob, version number(10) ); Here is...
Categories: DBA Blogs

Query not working in Oracle , Missing expression error

Mon, 2018-01-22 20:46
i want to get column 2 of y table if column 1 of y table is equal to column 1 of z table this query working in mysql but,this query not working in oracle am getting missing expression error....can u please help me to sort this issue
Categories: DBA Blogs

Data Guard And Notification

Mon, 2018-01-22 02:26
As part of the my project, we are migrating legacy system to new system. As a part of one process, we have reporting data base from which different reports are generated. Report generation is started by trigger(alert) once the replication of producti...
Categories: DBA Blogs

how to recover a bad block in a big file tablespace

Mon, 2018-01-22 02:26
some days ago,I asked a question about big file tablespace vs normal small file tablespace, you said "That said, its rare to need to recover a particular datafile - the most common scenarios are recover a database, or recover/fix some blocks. In eith...
Categories: DBA Blogs

How many context switches my session does?

Mon, 2018-01-22 02:26
Hello, My questios is already in subject. What performance views has information about about PL/SQL and SQL context switches? SELECT n.Name FROM v$statname n WHERE n.Name LIKE '%context%' Returns only "OS Voluntary context switches" and "OS...
Categories: DBA Blogs

two_tasks

Mon, 2018-01-22 02:26
would like to know why it is not advisable to use "two_tasks" Thank you Regards
Categories: DBA Blogs

Primary Key

Mon, 2018-01-22 02:26
Dear Sir, When asked what is the difference between Primary Key and Unique Key , People say Primary Key cannot be NULL, and Unique Key can be NULL. My Question is If we add a NOT NULL constraint on Unique Key , we can use Unique key constraint...
Categories: DBA Blogs

Best Practice: Does the SQL Mantra simplify Data Verification?

Fri, 2018-01-19 19:46
Tom-- I subscribe to your SQL mantra for data (and truly, is there anything else? :)) which is: 1. Do it in a single SQL statement if at all possible. 2. If you cannot, then do it in PL/SQL (as little PL/SQL as possible!). 3. If you cannot do it...
Categories: DBA Blogs

Loading records in separate rows using sqlloader

Fri, 2018-01-19 19:46
Hi, First of all thanks a lot for answering my previous questions, that helped me a lot. Now I came up with a new questions regarding SQL loader. So, basically I have a file that contains a records like below A|B|C|D| Now, I have a requirem...
Categories: DBA Blogs

Switch objects to add where clause

Fri, 2018-01-19 19:46
Hi , We have a process that cannot be changed and that executes a query over a specific table. Due to a new development it is necessary to had a new statment to the WHERE clause of the query. But the executable cannot be changed. So the idea w...
Categories: DBA Blogs

Transaction set consistency

Fri, 2018-01-19 19:46
hello , i am reading <<Database Concepts>> , i can not understand "Transaction set consistency" clearly , will you explain this to me pls ? can you show me some simple examples to show what is "Transaction set consistency" ? thanks . the...
Categories: DBA Blogs

Scheduler Jobs stopped running after delete job_creator

Fri, 2018-01-19 01:26
I have 2 jobs that stopped running. They were marked as BROKEN. On *_SCHEDULER_JOB_LOG view it shows REASON="Job creator:[bda_user_xyz...] dropped". Both jobs are setted as MAX_FAILURES = null Does any one know if this is a bug? I can't find ...
Categories: DBA Blogs

Table Statistics Get Null or Empty

Fri, 2018-01-19 01:26
What could be the possible reason(s) why the table statistics (DBA_TAB_STATISTICS) got null or empty i.e. num_rows, last_analyzed columns? At certain date <b>DBA_TAB_STATISTICS</b> num_rows, last_analyzed columns have values (not empty/null), and...
Categories: DBA Blogs

Google friendly application URLs in APEX

Fri, 2018-01-19 01:26
Hi Now a days, there had been lots of discussion about having google friendly url for a web application. I have gone thru many links, but still confused. My question is - if I create a public application with Oracle Apex, could google able to ...
Categories: DBA Blogs

Analytical Function to compute running daily overtime by week

Fri, 2018-01-19 01:26
Hi there, I may be overthinking this query and would really appreciate some input/kick in the pants. How in the heck do I get daily overtime based on a 40 hour work week? If the week isn't complete but an employee has racked up more than 40 hours...
Categories: DBA Blogs

Reading image file

Fri, 2018-01-19 01:26
Hello MR.TOM please i have answer <b>Reading image file to custom table and export the image into a new file. Let's say we have a file called 'horse.jpg' and upload it to a table. After that you wat to export it to a new file horse1.jpg...
Categories: DBA Blogs

Error importing a DMP file to a very different database

Thu, 2018-01-18 07:06
I created a completely new oracle database and I am trying to import a DMP file from a full backup of another database and I am getting several errors. Can you help me: <b>Command:</b> impdp system/welcome1 full=yes directory=BACKUPSDR dumpfile=bc...
Categories: DBA Blogs

Making a URL call in PL/SQL

Thu, 2018-01-18 07:06
Hi Tom, I want to open Apex Application in New Window or New Tab through Oracle EBS Home page. I have tried with different method and finally came up with solution based on below link https://asktom.oracle.com/pls/apex/asktom.search?tag=making...
Categories: DBA Blogs

Pages