Oracle: Clone An User With PL/SQL – Tablespace Quotas, Role Grants/Default Role, Object Grants And System Grants

As an Oracle DBA, you are very likely to get requests somewhat like this: Create an account for Sam Hill. The privileges should look exactly like Rob Nixon. If you are not into automating everything, your first instinct would be to fire-up an IDE like Toad or SQL Developer and script out the source user, …

Advertisement

PowerShell – Copy SQL Server Tables – Structure, Data & Indexes To Another Database/Instance

  UPDATE Mar 25, 2021: I have created an updated version of the script with enhancements and sample usage that is available at my GitHub: https://github.com/SQLJana/PowerShell/blob/c6cbe1d5b4f97026d1b00df59403dcd1ed367065/Copy-SQLTable.ps1 Requirement: Recently I got a request from a user that he wanted to copy a specific set of tables and their indexes into a new database to ship to …

Oracle Gotcha For The SQL Server Developer – DDL’s COMMIT Transactions Implicitly!

If you are primarily a SQL Server developer and you are moving to Oracle, this is one of the nastiest surprises in store for you. You are so used to rolling back everything including DDL in SQL Server transactions but in Oracle, DDL inside transactions act as COMMIT. Fear not though, there are a ton …

Oracle – TRUNCATE vs DELETE – Spoiler: TRUNCATE Wins & Why? Hours vs Seconds!

Why DELETE is bad? In Oracle, when it comes to deleting  ** A L L **   the data from a table (clearing the contents of a staging table for example), using a DELETE statement is the most inefficient choice. Here are some reasons why DELETE is bad It uses UNDO It uses REDO It fires …

Oracle UNDO – A Basic Explanation

You might have heard the terms UNDO and REDO thrown around in conversations around space usage. In this tip, let us get a basic idea of what UNDO (formerly called ROLLBACK) is in Oracle. I promise you that this will be an interesting read and you will be happy you read this. Unlike SQL Server …