homme.io

Clean.Precise.Quick.

Oracle

«Чу́дище о́бло, озо́рно, огро́мно, стозе́вно и ла́яй»

---

ALL и ANY

Drop tablespace with its datafiles

Oracle в Россию доставят ракеты с ядерными боеголовками (с)

View open sessions

ORA-01000: maximum open cursors exceeded sql

OCI Examples from ORACLE

Toggle On DBMS_OUTPUT in sqlcl

About Oracle Forms killing by ORACLE (с)

View compiled with errors

Get DDL

10 Oracle UNDO Tablespace Management Examples (с)

Табличные пространства Oracle

Ошибка при подключении: ORA-28040: No matching authentication protocol exception

Useful commands

OCI: memory leaks

Кодировка в командной строке при экспорте

List all table and column privileges

Grant permissions for Package Body

Instant Client Installation Guide for MacOS X

About LD_LIBRARY_PATH and application configuration files

Oracle Forms 6i

Check listening 5500 port

Oracle EM

About DBMS_XDB_CONFIG.SETGLOBALPORTENABLED

Notes for installing Oracle 19c EE on OraLinux 7

Is Globalport Enabled

Good output format in SQL*Plus

Monitor PGA

Restore spfile

Size of a Oracle datafile (and temp datafile)

Monitor temporary tablespace usage

Increase SGA: ORA-00845: MEMORY_TARGET not supported on this system

Display PLAN_TABLE

Notes for installing Oracle 19c RPM on OraLinux 7

If autotrace not working

SQLcl

Show indexes

Decrease TEMP tablespace

View default tablespace (and temp) for user

ORA-65096: invalid common user or role name

Download Java SDK from OTN via wget

Notes for installing Oracle 18c XE on OraLinux 7(.6)

How to run scripts in Oracle

ORA-01031 when trying to ALTER INDEX REBUILD ONLINE

PL/SQL Developer: Session browser - what privileges are needed?

Reducing datafile size to recover free space

Пятнадцать вещей об Oracle, от которых должны отучиться АБД (c)

Основание компании Oracle (с)

TEMP-segment usage