Home

Understanding Data Pump IMPDP TABLE_EXISTS_ACTION Options: APPEND, REPLACE, SKIP, and TRUNCATE

Learn about the Oracle Data Pump TABLE_EXISTS_ACTION parameter and its options: SKIP, APPEND, TRUNCATE, and REPLACE. Understand how to handle existing tables during imports with practical examples and best practices.
Continue reading →: Understanding Data Pump IMPDP TABLE_EXISTS_ACTION Options: APPEND, REPLACE, SKIP, and TRUNCATE
Svn client error svn: E160006: Invalid revision number ‘-1’

Topic : svn: E160006: Invalid revision number ‘-1’ I have recently come across this error when I installed the svn client on my machine. I have the latest version of tortoise svn client on my local machine. After install I used to get this weird error when ever I used…
Continue reading →: Svn client error svn: E160006: Invalid revision number ‘-1’
Duplicate values in a table

Create table sql : CREATE TABLE ABC ( ID NUMBER , NAME VARCHAR2(20 BYTE) ) ;Lets insert duplicate values into it: INSERT INTO ABC (ID, NAME) VALUES (’15’, ‘f’);INSERT INTO ABC (ID, NAME) VALUES (’15’, ‘f’);INSERT INTO ABC (ID, NAME) VALUES (’15’, ‘f’);INSERT INTO ABC (ID, NAME) VALUES (’11’, ‘B’);INSERT…
Continue reading →: Duplicate values in a table
grant permissions on all tables to a user

Grant select permission on all tables in logged in schema to a user/role: declarecursor c1 is select table_name from user_tables;cmd varchar2(200);beginfor c in c1 loopcmd := ‘GRANT SELECT ON ‘||c.table_name||’ TO &&YOURUSERNAME’;execute immediate cmd;end loop;end; Note :you change the select to what ever permissions you want to grant. This will…
Continue reading →: grant permissions on all tables to a user
adding a primary/unique key to existing table and updating values

Learn how to add a primary/unique key to an existing Oracle table and update its values using sequences. This article provides clear steps and PL/SQL examples to automate assigning sequential IDs.
Continue reading →: adding a primary/unique key to existing table and updating values
Oracle Shrink Table – regain your space back

I believe this is better explained with an example.Sql code: lets first check if your database table spaces that re in manual and auto segment space management. SELECT tablespace_name, extent_management, segment_space_management FROM dba_tablespaces; TABLESPACE_NAME EXTENT_MANAGEMENT SEGMENT_SPACE_MANAGEMENT—————————— —————– ————————SYSTEM LOCAL MANUAL SYSAUX LOCAL AUTO UNDOTBS1 LOCAL MANUAL TEMP LOCAL …
Continue reading →: Oracle Shrink Table – regain your space back
OCA 1Z0-051 dumps

1Z0-051 dump pdf free download – Oracle 11g SQL Fundamentals I Download Here: 1Z0-051-1 Download Here: 1Z0-051-2 Exam Details : Oracle Database 10g and 11g: SQL Fundamentals I 1Z0-051 Exam Number: 1Z0-051 Associated Certifications: Oracle Database 11g Administrator Certified Associate Exam Product Version: SQL and PL/SQL, Exam Price: US$…
Continue reading →: OCA 1Z0-051 dumps
1Z0-052 dump pdf free download

Oracle Certified Associate – OCA 1Z0-052 dump pdf free download – Oracle 11g Database Administration I Download Here : 1Z0-052Exam Details :Oracle Database 11g: Administration I 1Z0-052 Exam Number: 1Z0-052 Associated Certifications: Oracle Database 11g Administrator Certified Professional Exam Product Version: Oracle Database 11g, Exam Price: US$ 245 Duration: 90 minutes…
Continue reading →: 1Z0-052 dump pdf free download
Applying CPU Patch On Primary Database Server Environment

Applying CPU Patch On Primary Database Server Environment. Step 1: Incase if you have standby server. Now disable log shipping on the primary database by setting the log_archive_dest_state_2 to disable. As I said earlier, parameter log_archive_dest_2 on my primary database is set to point to the standby database. SQL> alter…
Continue reading →: Applying CPU Patch On Primary Database Server Environment
Applying CPU Patch in a dataguard (Physical Standby) environment

Here is a brief explanation on how to apply CPU(Critical Patch Update) in a dataguard environmentIn this demo, I am applying PSU 11.2.0.4.2 on the Primary and standby databases. Standby Database Name :ORCL_STBYPrimary Database Name : ORCL Primary Server: [oracle@PRIM ~]$ sqlplus sys/oracle@srprim as sysdba SQL*Plus: Release 11.2.0.2.0 Production on…
Continue reading →: Applying CPU Patch in a dataguard (Physical Standby) environment