Database-Box: How to Use Oracle Data Pump with Oracle RAC

Database-Box: How to Use Oracle Data Pump with Oracle RAC: How to Use Oracle Data Pump with Oracle RAC📚 Using Oracle Data Pump in an Oracle Real Application Clusters (Oracle RAC) environment require...

Minimalistic Oracle: How to unload rows in an Oracle database to disk u...

Minimalistic Oracle: How to unload rows in an Oracle database to disk u...: In sqlcl, execute these lines to unload SCOTT.EMP to disk: set arraysize 200 set load batch_rows 200 UNLOAD TABLE SCOTT.EMP DIR /datadisk1/...

Database-Box: A strong technical review on Oracle Bigfile Tables...

Database-Box: A strong technical review on Oracle Bigfile Tables...:  A strong technical review on Oracle Bigfile Tablespace and exploring the challenges & Concerns for DBAs Bigfile Tablespaces in Oracle...

Minimalistic Oracle: How to delete all lines above and below the curren...

Minimalistic Oracle: How to delete all lines above and below the curren...: In vi (or vim), you can delete all lines above the current line with this one simple command: :1,.−1d To delete all rows above the current...

Minimalistic Oracle: Convert all contents in a file to lower case using...

Minimalistic Oracle: Convert all contents in a file to lower case using...: Open your file in vi vi myfile Press the escape key to enter interactive mode, then type :%s/.*/\L&/ Press escape, then save + exit ...

How to list the postgres processes running on your server and what their jobs are

Minimalistic Oracle: How to list the postgres processes running on your...: A neet little trick I learned from the series " Mirage of memory, part 2: PSS " ps -fu postgres | grep $(pgrep -f postmaster) p...

ZDM Migration : Migrate from an On-Premises 19c non-Container Database to Oracle Database 23ai Container Database

Migrate from an On-Premises 19c non-Container Database to Oracle Database 23ai Container Database. The details are available at below link.

 ZDM Migration from 19c to 23ai