Command Reference
Every feature of this project is available as a single command through the local-26ai.sh wrapper. This page lists all of them. Run local-26ai.sh --help to see the same overview in your terminal.
local-26ai.sh <command> [arguments]Containers
Section titled “Containers”| Command | Description |
|---|---|
start | Start the database and ORDS containers. |
stop | Gracefully shut down the database, then stop the containers. |
See Common Tasks → Managing Containers.
Users & Workspaces
Section titled “Users & Workspaces”| Command | Description |
|---|---|
create-user <name> | Create a database schema and APEX workspace with all development grants. Use --skip-workspace for a schema only, --compress to store its data compressed. |
clear-schema <name> | Drop all objects in a schema, keeping the schema itself. Great for re-testing install scripts. -y skips the confirmation. |
drop-user <name> | Completely remove a schema including its tablespace and datafile. -y skips the confirmation. |
See Creating Users.
Backups & Import
Section titled “Backups & Import”| Command | Description |
|---|---|
backup-all | DataPump-export every schema including APEX workspaces, applications, and ORDS modules to ./backups/export. |
backup-user <name> | DataPump-export a single schema including its APEX workspace and applications. |
import-backup <name> | Restore a schema from a previous backup. Creates the user first if it doesn’t exist. |
import-datapump <name> [-rs <target>] | Import a DataPump dump for a schema. With -rs the dump is remapped into a different schema name. |
import-all | Import every export file found in ./backups/import — useful for bulk migration. |
sync-backups-folder | Copy ./backups/import into the container’s DataPump directory and pull new exports back out. |
fix-ws-group-ids | Remove problematic group IDs from APEX workspace export files in ./backups/import so they re-import cleanly. |
See Backups and Common Tasks → Workspace Import/Export.
Testing Installs
Section titled “Testing Installs”| Command | Description |
|---|---|
test-app-install <file.sql> | Install an APEX application export into the clean UC_TESTINSTALL_1 schema and report object counts, invalid objects, and dependency scan results. -y skips the confirmation. |
test-script-install <file.sql> | Run any SQL script in the clean UC_TESTINSTALL_1 schema and report object counts and invalid objects. -y skips the confirmation. |
Disk Space
Section titled “Disk Space”| Command | Description |
|---|---|
used-space | Show database space usage against the 12GB Free-edition limit, per tablespace. |
shrink-space | Shrink tablespaces and datafiles to reclaim unused space. |
compress-space <name> | Enable Advanced Compression on a schema’s tablespace, rebuild its objects compressed, and return the freed space to the OS. -y skips the confirmation. |
See Common Tasks → Maintenance Tasks.
Setup & Maintenance
Section titled “Setup & Maintenance”| Command | Description |
|---|---|
after-first-db-start | Install APEX and apply dev-friendly defaults. Run automatically by install.sh — you only need it for manual setups. |
upgrade-apex | Download the latest APEX version, run the installer, copy the images, and reapply workspace settings. |
unexpire-accounts | Unlock and unexpire APEX/ORDS accounts — the fix for “Account Is Locked” messages. |
disable-password-expiration | Stop database account passwords from expiring in the future. |
disable-archive-logs | Disable archive logging to save disk space (recommended for dev). |
create-self-signed-certificates | Create self-signed SSL certificates so ORDS serves HTTPS on port 8443. Run with sudo. |
install-dbms-cloud | Install the DBMS_CLOUD package into the database. |
See Upgrade APEX and Common Tasks.