Master Oracle SQL*Plus: Essential Commands for Tablespaces, Partitions, and External Data

This guide provides a comprehensive, step‑by‑step tutorial on using Oracle SQL*Plus for connecting to databases, querying tables, saving and executing scripts, handling variables, formatting output, managing tablespaces, creating external tables, and defining various partitioning strategies.

Database AdministrationExternal TablesOracle

0 likes · 11 min read

Master Oracle SQL*Plus: Essential Commands for Tablespaces, Partitions, and External Data

ITPUB

Sep 26, 2016 · Databases

How to Manually Delete an Oracle Database and Clean Up ASM Files

This guide provides step‑by‑step commands for safely stopping listeners, locating data, log and control files, dropping the database, and removing residual files both for file‑system and ASM Oracle databases.

ASMOracleSQL*Plus

0 likes · 6 min read

How to Manually Delete an Oracle Database and Clean Up ASM Files

ITPUB

Jun 13, 2016 · Databases

How to Connect to Oracle When Your Password Contains an @ Symbol

When an Oracle user password includes the '@' character, standard sqlplus login fails with a connection string parsing error; escaping the '@' by using backslashes or enclosing the password in double quotes restores successful connection.

Database ConnectionEscape CharacterOracle

0 likes · 3 min read

How to Connect to Oracle When Your Password Contains an @ Symbol