:

The Latest Oracle Posts

Enterprise Manager Library Job Removal

One of the main purposes of the Enterprise Manager (EM) software is to centralise the management of various components across your infrastructure. Using the EM software, you can schedule jobs to run against various targets. If, like me, you have lots of jobs running against the databases, you may want to delete them all at […]

Continue Reading

ORA-12154: TNS:could not resolve the connect identifier specified

I came across a little Oracle issue this morning which can be quite confusing at times. It’s to do with compilation of a package which has references across a database link. Here is what we were seeing from our database warehouse: USER1@DW> EXEC CONFIG_PKG.UPDATESOURCEROW ERROR at line 1: ORA-12154: TNS:could not resolve the connect identifier […]

Continue Reading

Oracle 10g RMAN Compression

If you have large databases and you use RMAN to back them up, and you are a little concerned with how much space they currently take up, this could be just the tool for you. Previously, it was not possible to backup your database with RMAN and conserve space using compression; this had to be done afterwards using some […]

Continue Reading

DBMS_SPACE.SPACE_USAGE

When using this procedure you must ensure that the  tablespace in which the segment resides has segment space management set to  AUTO. If it is manual you are likely to get the following error: ORA-10614: Operation not allowed on this segment Cause: This procedure can be used only on segments in  tablespaces with AUTO SEGMENT […]

Continue Reading

ORA-38792: encountered unknown flashback record

I was attempting to flashback my test database after having created the guaranteed flashback restore point in Oracle version 10g, and subsequently upgrading the DB to 11g. SQL> flashback database to restore point PRE_CHANGE_DB; flashback database to restore point PRE_CHANGE_DB * ERROR at line 1: ORA-38792: encountered unknown flashback record from release 11.0.0.0.0 According to […]

Continue Reading

ORA-00997: illegal use of LONG datatype

I had a requirement to keep track of the LOBs which were in the DB, their partition names and high values. We wanted to keep this information in a small lookup table so I first attempted to run a Create Table As Select (CTAS) statement, to which I received the following error: ERROR at line […]

Continue Reading

Oracle RMAN – Backup & Recovery

Oracle RMAN – Backup & Recovery

In this article I would like to first go through a quick Q&A and then cover some of the RMAN fundamentals in a little more detail. If you are not already backing up your database, read on and start doing it. Note: I will be making this information as easy to digest as possible. If […]

Continue Reading

ORA-14160: this physical attribute may not be specified for a table subpartition

The ORA-14160 this physical attribute may not be specified for a table subpartition erro occurred when I forgot to add the comma and the end of each subpartition specification. 9 times out of 10 this error will be the result of a typo or incorrectly specified table definition. In the example below, commas should be […]

Continue Reading

NID-00107: File I/O error on datafile

I was using the NID utility the other day to change the name of a database that I had just restored. The restore had been carried out using data pump and the transportable tablespaces feature. When using NID I got the following error: NID-00107: File I/O error on datafile “R:\CONTROL01.CTL” during block 1 offset operation  (27047/kunidb1c) This […]

Continue Reading

Rename Oracle Database – NID Command Explained

You can use the NID command to change an Oracle database’s name and/or ID. This is useful, for example, when making a clone of a production database and wanting to use it in development. You may find that when using it you come across the NID-00107: File I/O error on datafile or perhaps the NID-00137: […]

Continue Reading