Skip to content
Saturday, June 25, 2022
Database Learners
Menu
  • About Database
  • Oracle
    • ASM
    • Data Pump
    • Backup and Recovery
    • Patching and Upgradation
    • Performance Tuning
    • Data Guard
    • Real Application Cluster
    • Golden Gate
    • PL/SQL
  • MySQL
  • PostgreSQL
  • MongoDB
  • MS SQL Server
  • SQL
  • Linux
  • About Me
  • Contact Us
  • Home
  • DB Scripts

Category: DB Scripts

Drop all tables in Oracle DB (Schema)

2 September 20204 September 2020 Administrator

Imagine you have a list of tables in your Oracle DB and you want to drop them all using a client like SQLDeveloper. That’s easier said then done, as Read More…

Grant Select on all Tables Owned By Specific User

1 September 20201 September 2020 Administrator

BEGIN FOR R IN (SELECT owner, table_name FROM all_tables WHERE owner=’TheOwner’) LOOP EXECUTE IMMEDIATE ‘grant select on ‘||R.owner||’.’||R.Read More…

How to find out total memory used by each database ?

26 August 202026 August 2020 Administrator

The following query can be used to determine the memory usage rates in Oracle databases. If there is an increase in the memory values ​​from timeRead More…

Script to Create a New Oracle Database

21 August 202021 August 2020 Administrator

If you need to create a database in Oracle 10g but doesn¥t want to use the DBCA feature or are unable to use it, you could simply follow the followiRead More…

Script to Create a New Oracle Database

17 August 202017 August 2020 Administrator

If you need to create a database in Oracle 10g but doesn¥t want to use the DBCA feature or are unable to use it, you could simply follow the followiRead More…

In SQL*Plus, how to change the prompt to show the connected user and database?

14 August 202014 August 2020 Administrator

In SQL*Plus, how do I change the prompt to show the connected user and database? Connect as oracle user and add the following line at the end of tRead More…

Generating DDL of a schema

14 August 202014 August 2020 Administrator

These functions can be used as part of a select statement to produce output for groups of objects, such as object creation scripts, like the one showRead More…

Database health checks in Oracle

14 August 202014 August 2020 Administrator

Performing Database health checks, when there is an issue reported by Application users. Check the Database detailsMonitor the consumption of resoRead More…

DBA SCRIPTS

30 March 20152 August 2020 Administrator

1) DROP USER OBJECTS: conn username/password —>>> MANDATORY to connect as a user declare
cursor fkc is select table_name,
constraint_nameRead More…

Script for getting Oracle table size

27 March 20155 August 2020 Administrator

There is no oracle defined function for getting size of a table. After all if it is easy with one simple query who will require a function. Isn’t it?ARead More…

Posts navigation

Older posts

Recent Posts

  • How to Optimize MySQL Tables and Defragment to Recover Space
  • ORA-01031: Insufficient Privileges When Connect As Sysdba
  • Oracle RAC log files locations
  • Drop all tables in Oracle DB (Schema)
  • How to Determine If the Oracle Redo Log File Size Is a Problem

Categories

  • ASM (40)
  • Backup and Recovery (52)
  • Data Guard (36)
  • Data Pump (28)
  • DB Scripts (26)
  • General (1)
  • Golden Gate (7)
  • Interview Questions (24)
  • Linux (86)
  • MS SQL Server (8)
  • MySQL (120)
  • ORA-Errors (45)
  • Oracle (301)
  • Oracle 10g (19)
  • Oracle 11g (24)
  • Oracle 12c (9)
  • Oracle RAC (101)
  • Oracle XE (7)
  • Patching and Upgradation (19)
  • Performance Tuning (61)
  • PL/SQL (26)
  • RMAN (85)
  • SQL (32)

Visitors

  • 0
  • 28
  • 32,397

Reference Links:

  • https://docs.oracle.com/en/database/index.html
  • https://dev.mysql.com/doc/
  • https://docs.mongodb.com/manual/
  • https://docs.microsoft.com/en-us/sql/sql-server/?view=sqlallproducts-allversions
  • https://www.postgresql.org/docs/current/
@2021 databaselearners.com | Theme: BlogMagazine by Dinesh Ghimire.