-
Fixing ORA-31633: Unable to Create Master Table During Data Pump Import
Continue reading →: Fixing ORA-31633: Unable to Create Master Table During Data Pump ImportLearn how to resolve the ORA-31633: Unable to Create Master Table error in Oracle Data Pump Import. This guide covers troubleshooting steps, necessary privileges, and best practices to ensure a successful import.
-
Svn client error svn: E160006: Invalid revision number ‘-1’
Continue reading →: 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…
-
Duplicate values in a table
Continue reading →: Duplicate values in a tableCreate 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)…
-
grant permissions on all tables to a user
Continue reading →: grant permissions on all tables to a userGrant 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…
-
adding a primary/unique key to existing table and updating values
Continue reading →: adding a primary/unique key to existing table and updating valuesLearn 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.
-
Oracle Shrink Table – regain your space back
Continue reading →: Oracle Shrink Table – regain your space backI 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 …
-
OCA 1Z0-051 dumps
Continue reading →: OCA 1Z0-051 dumps1Z0-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 …
-
1Z0-052 dump pdf free download
Continue reading →: 1Z0-052 dump pdf free downloadOracle 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:…
-
Applying CPU Patch On Primary Database Server Environment
Continue reading →: Applying CPU Patch On Primary Database Server EnvironmentApplying 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…



