Blog Posts

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

October 24, 2014

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.
Svn client error svn: E160006: Invalid revision number ‘-1’

October 20, 2014

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 to do check out. …
Duplicate values in a table

September 24, 2014

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 INTO ABC (ID, NAME) VALUES…
grant permissions on all tables to a user

September 18, 2014

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 be very helpful in case…
adding a primary/unique key to existing table and updating values

September 12, 2014

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.