Mike Driver
Acquired Stardust
d e v o n
No title available
I'd rather be in outer space đž
Keni
YOU ARE THE REASON
Game of Thrones Daily
art blog(derogatory)
ç„æ„ / Permanent Vacation
â
â
Today's Document
Alisa U Zemlji Chuda
Cosimo Galluzzi
⣠Chile in a Photography âŁ
he wasn't even looking at me and he found me
2025 on Tumblr: Trends That Defined the Year
ellievsbear
Peter Solarz
seen from India
seen from United States
seen from Netherlands
seen from United States
seen from India
seen from United States
seen from Mexico
seen from Malaysia
seen from United Kingdom
seen from China
seen from Germany
seen from Netherlands
seen from Canada
seen from United States
seen from United States
seen from Malaysia
seen from United States
seen from Algeria
seen from Norway
seen from Malaysia
@oraclerider
Check Status of Received and Applied Archives in Oracle Dataguard
Oracle Data Guard is a high-availability, disaster recovery, and data protection solution for Oracle databases. This article provides a comprehensive guide on checking the status of received and applied archives in Oracle DataGuard to maintain a seamless replication process. Archive Log Management in Oracle Data Guard Oracle Data Guard works by transmitting redo logs from the primary databaseâŠ
View On WordPress
How to Setup Oracle to Startup Automatically if the System is Restarted
Every Oracle system has an â/etc/oratabâ file, which is created after Oracle installation by the Root.sh script. This file contains entries for every database on the system. âSetup Oracle to Startup Automatically if the System is Restartedâ To complete this process, you need to log in with the root user. Setup Oracle to Startup Automatically if the System is Restarted Follow the below stepsâŠ
How to check when last stats was gathered in Oracle?
In this article, we will explore how to check the last analyzed date of tables and indexes in Oracle, or in other words, how to determine when the statistics were last gathered. âcheck last gather stats in oracleâ. Check last gather stats in oracle Here are the complete steps to retrieve the latest statistics gathering information in an Oracle database. You also learn: How to install,âŠ
View On WordPress
Oracle RMAN Tutorial
In this document, we will learn what is RMAN and how to take Oracle Database Backup â âOracle RMAN tutorialâ. What is Oracle RMAN used for? RMAN, or Recovery Manager, is a tool created by Oracle to handle backup and recovery tasks within Oracle databases. It simplifies processes such as data file backups, control file backups, and managing archived redo logs. RMAN offers features likeâŠ
View On WordPress
Install Linux in Oracle VirtualBox
In this article, we will learn how to install Linux in Oracle VirtualBox step by step. We are demonstrating Oracle Linux 8.4 installation here, the steps are almost the same for Redhat Linux/Centos, etc. Required Softwares Download Oracle VirtualBox Oracle Linux iso Step 1: Create a Virtual Machine Open VirtualBox software and create a new virtual machine first. Name: Enter your virtualâŠ
View On WordPress
Resolve error in invoking target agent nmhs of makefile
#oracle #oracledba #oracledatabase #oraclecloud #oraerror
During Oracle 11.2.0.4 installation we facing the following message âerror in invoking target agent nmhs of makefileâ. Donât worry about it just follow the below steps and you will resolve it succesfully. How to solve error in invoking target agent nmhs of makefile Donât click on Abort or Continue, to solve error in invoking target âagent nmhsâ of makefile error you must follow the belowâŠ
View On WordPress
Purge RECYCLEBIN in Oracle
the RECYCLEBIN feature by default is enabled. To protect eccidentally dropped tables. "purge recyclebin in oracle".
In Oracle, the RECYCLEBIN feature by default is enabled. To protect eccidentally dropped tables. âpurge recyclebin in oracleâ. Oracle scripts. SQL> col OBJECT_NAME for a32 SQL> col ORIGINAL_NAME for a10 SQL> set lin 300 pagesize 200 SQL> select object_name, original_name, type, can_undrop as "UND", can_purge as "PUR", droptime 2 from recyclebin; OBJECT_NAME ORIGINAL_N TYPE UND PURâŠ
View On WordPress
How to get tablespace DDL in oracle
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. SQL> sqlplus / as sysdba Step 2: Execute the following SQL statement to set the output format for the DDLâŠ
View On WordPress
How to create tablespace in Oracle
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 CREATE TABLESPACE test_ts DATAFILE '/u01/app/oracle/oradata/test_ts01.dbf' SIZE 100M AUTOEXTEND ON NEXTâŠ
View On WordPress
Switchover steps in Oracle 12cHow to switch over in Oracle?Switchover steps in Oracle 12c
Switchover steps in Oracle 12cHow to switch over in Oracle?Switchover steps in Oracle 12c
In this article we are going to learn how to performe switchover steps in Oracle Data Guard environment. Here we performing manual switchover activity. So, follow me carefully. âSwitchover steps in Oracle 12câ,âOracle database switchover steps 19câ, âOracle Active Data Guard switchoverâ, âSwitchover and switchback in Oracle 12câ, âSwitchover steps in oracle 11gâ, âFailover steps in OracleâŠ
View On WordPress
Run Expdp Jobs in Background
In this article we are going to learn how to run expdp jobs in background (nohup) step by step. Keywords ânohup expdp / as sysdbaâ, âexpdp parfile userid=/ as sysdbaâ, âHow to run expdp in nohupâ. Steps to run export in background Follow the below steps to run expdp/impdp in nohup. Step 1: Create parfile The parfile is help us to execute export jobs, we can execute all datapump commandsâŠ
View On WordPress
How to Check Oracle UPTIME AND STARTUP history?
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". #oracle #oracledba #databaseadmin #oracledatabase
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 Instagram Facebook LinkedIn Twitter Check Last Startup Time Here is the query which is helping us to check the oracle database last startup time. âOracle UPTIME AND STARTUPâŠ
View On WordPress
Create spool file with timestamp in oracle
how to create spool file with timestamp oracle database. #oracle #oracledba #oracledatabase #oracleadministrator
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 Instagram Facebook LinkedIn Twitter spool file with timestamp oracle Login into database and follow the below steps. $sqlplus / as sysdba Step 1: Create a dummy column with noprint option. SQL> column dt new_value TDATEâŠ
View On WordPress
How to Generate table DDL
in this practice we are going to learn how to generate table DDL, view DDL, Materialized View DDL and user DDL.
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 DDLGET ROLE DDL Get more oracle scritps How do you get DDL of a table in Oracle? In real time environment some times we need to DDL of an existing table. We can perfo this activity with the help of dbms_metadata.get_ddlâŠ
View On WordPress