In Oracle, the RECYCLEBIN feature by default is enabled. To protect eccidentally dropped tables. “purge recyclebin in oracle”. Oracle scripts. Other commands to purge recyclebin in oracle Here are the more commands to check RECYCLEBIN, Check recycle-bin from SYSDBA account Check Current session RECYCLEBIN Purges recyclebin from current session Using the below commands we can … Read more
To get the tablespace DDL (Data Definition Language) in Oracle, you can use the DBMS_METADATA package. “tablespace DDL in oracle” Get DDL for specific tablespace Step 1: To get tablespace ddl in oracle first connect to your Oracle database using a tool such as SQL*Plus or SQL Developer. Step 2: Execute the following SQL statement … Read more
In Oracle, a tablespace is a logical storage container that can hold one or more database objects, such as tables, indexes, and other schema objects. The following is an example of a Data Definition Language (DDL) create tablespace in Oracle. Statement to create tablespace in Oracle Let’s go through each component of this create a … Read more
Hello guys, the Oracle uptime and startup history is recorded in alert log files. But you also check these details using SQL Queries. “Oracle UPTIME AND STARTUP history”. Connect with us on Social Network Oracle UPTIME AND STARTUP history Heres is the steps to check oracle database uptime and startup history step by step. 1. … Read more
In this article we are going to learn how to create spool file with timestamp oracle database. “oracle spool date format”. Connect with us on Social Network spool file with timestamp oracle Login into database and follow the below steps. Step 1: Create a dummy column with noprint option. Step 2: Select sysdate with reference … Read more
Hi, in this practice we are going to learn how to generate table DDL, view DDL, Materialized View DDL and user DDL. You also read below articles: DB LINK DDL GET TABLESPACE DDL GET ROLE DDL Get more oracle scritps How do you get DDL of a table in Oracle? In real time environment some … Read more
In this post, we will learn how to take rman backup with archivelog step-by-step guide. What is backup database plus Archivelog? The backup database plus archivelog command will create a database backup with archivelogs using the RMAN utility. RMAN Backup with Archivelog Or you can use the below script for the same task. Output from … Read more
I recently encountered a situation where the RMAN backup job was stuck. I ended the hung session as the database size was only four GB and it had been running for the last four hours. We made some changes to the RMAN command and ran the jobs again. It was completed in under an hour. … Read more