Arvind Toorpu

Blog Posts

  • 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 be very helpful in case…

  • adding a primary/unique key to existing table and updating values

    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.

  • 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             MANUAL                  USERS                          LOCAL             AUTO                     …

  • 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$ 125 Duration: 120 minutes Number…

  • 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 Number of Questions: 70 Passing…

Hello,

Arvind Toorpu

I am a Database Admin/Architect with over 14+ years of experience managing multiple DBMS systems

Let’s connect

Join the fun!

Stay updated with our latest tutorials and ideas by joining our newsletter.

Recent posts