I have a text file with following details. I wanted to create a simple report as formatted in the output. See a simple awk program to generate the report.
In many cases as a DBA or Unix admin you have to find out which directory is consuming more space. Probably in some directories consuming more space because of huge log files or some trace files.
This impdp parameter is used to rename the table during the import operation. These are the main activities can be performed by this parameter.
- Rename the one or more tables into the same schema during import
I have a text file called dat.txt and it having some generic text characters in the first and last of every line. I wanted to remove these charcters. See different options by using vi, awk, sed.
I have a file called dat.txt with few lines. I wanted to count and remove the duplicate lines.
$ cat dat.txt
I have a text file called dat.txt and it having some text data which is highly confidential. I wanted to replace some few characters with x to make it invalid. See different options with vi, awk, sed.
Oracle provides a DBMS_LOCK.Sleep procedure to suspend the session for given period of time. The argument for the procedure is time in seconds. Seconds can be in decimals also.
cp command provides an option –p for copying the file without changing the mode, ownership and timestamps.
--preserve option gives you the provision to choose the options from
You can create soft links in Linux using cp and ln commands. Both commands will create soft links with –s option.
There are two commands to perform this task – rsync and cp command with –u option. In both cases it will copy all the files in the initial run and only modified file in the subsequent run.
Delete command on one table is working properly. But truncate command is failing with following error.
SQL> SELECT COUNT(*) FROM SCOTT.QII_TSKERR_CMSQTAB;
In Oracle 11gR2 you can create and keep different versions or editions of objects. The objects are limited to some set of objects which is not having the storage. You can see more details here with examples.Oracle Object Editions
In oracle you can create different versions for the objects which are not requiring the storage. For example Table requires storage and View doesn’t require the storage. These are the types of the objects can be editionable.
I have a dump file which is taken from different database with DBA user. I am trying to import the same dump to different database with different user. Data Pump import job failed with following error.
Oracle 11gR2 Impdp DATA_OPTIONS SKIP_CONSTRAINT_ERRORS: How to Skip Constraint Errors during Import?
DATA_OPTIONS parameter comes with impdp utility. By default this parameter is disabled during the import. You have to invoke it specifically to handle some special kind of data during the import operations.
As the name indicates the feature is for optimizing the RMAN backups. When you turn on this backup optimization parameter, RMAN skips the backing up the files which has been already been backed up to the same device. The main benefit out of this is it will reduce the unwanted space usage.
ASM database instance shutdown failed with following error.
SQL> conn / as sysasm
SQL> shut immediate;
Fix Oracle 11g Database Block Corruption? - Recovery Using RMAN Backup ORA-01578: ORACLE data block corrupted
Oracle database aler.log file shows following error. RMAN logs also reported the same error.
ORA-01578: ORACLE data block corrupted (file # 6, block # 881945)
ORA-01110: data file 6: '/u01/app/oracle/data/DEVQA/datafile/mgmt.dbf'
Here is my input data file and see the output as per the requirements below.
Suppose if you wanted to print the Unix man pages, it has to be copied to a single file. Normally man pages displays page by page. You can easily open the man pages in vi editor using combination following commands.
dd if=/dev/zero of=dummyfile bs=26214400 count=1
1+0 records in
1+0 records out
26214400 bytes (26 MB) copied, 0.063799 seconds, 411 MB/s
$ ls -ltr
Some Facts on Oracle Tempfiles:
If the database tempfile is in offline status then the bytes column of the dba_temp_files will be null. If the file system of the temporary file is having some problem then the corresponding tempfile status will move to offline
Oracle 11g Database Startup Failed: /dev/shm and ORA-00845: MEMORY_TARGET not supported on this system
I have modified or increased the value for the parameter MEMORY_TARGET and then Oracle 11g database startup failed with following error.
ORA-00845: MEMORY_TARGET not supported on this system