Command Reference
The local-26ai.sh wrapper gives you every feature of this project as a single command. This page lists all of them. Run local-26ai.sh --help to see the same list in your terminal.
local-26ai.sh <command> [arguments]Containers
Section titled “Containers”| Command | Description |
|---|---|
start | Start the database and ORDS containers. |
stop | Shut the database down cleanly, 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 an APEX workspace with all development grants. Use --skip-workspace for a schema only. Use --compress to store the data compressed. |
clear-schema <name> | Drop all objects in a schema and keep the schema itself. Use it to test an install script many times. -y skips the confirmation. |
drop-user <name> | Drop a schema with its tablespace and datafile. -y skips the confirmation. |
See Creating Users.
Backups & Import
Section titled “Backups & Import”| Command | Description |
|---|---|
backup-all | Export every schema with DataPump to ./backups/export, with the APEX workspaces, applications, and ORDS modules. |
backup-user <name> | Export a single schema with DataPump, with its APEX workspace and applications. |
import-backup <name> | Restore a schema from a backup. If the user does not exist, the script creates it first. |
import-datapump <name> [-rs <target>] | Import a DataPump dump for a schema. With -rs the script imports the dump into a different schema name. |
import-all | Import every export file in ./backups/import. Use it during a migration. |
sync-backups-folder | Copy ./backups/import into the DataPump directory of the container, and copy new exports back out. |
fix-ws-group-ids | Delete the group IDs from the APEX workspace export files in ./backups/import, so the files import correctly. |
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. Shows object counts, invalid objects, and the results of the dependency scan. -y skips the confirmation. |
test-script-install <file.sql> | Run any SQL script in the clean UC_TESTINSTALL_1 schema. Shows object counts and invalid objects. -y skips the confirmation. |
Disk Space
Section titled “Disk Space”| Command | Description |
|---|---|
used-space | Show the used database space per tablespace, against the 12GB limit of the Free edition. |
shrink-space | Shrink tablespaces and datafiles to reclaim unused space. |
compress-space <name> | Enable Advanced Compression on the tablespace of a schema, rebuild its objects in compressed form, and return the free space to the operating system. -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 the defaults for development. install.sh runs this command. You need it only for a manual installation. |
upgrade-apex | Download the latest APEX version, run the installer, copy the images, and set the workspace settings again. |
unexpire-accounts | Unlock the APEX and ORDS accounts. This corrects an “Account Is Locked” message. |
disable-password-expiration | Stop the passwords of database accounts from expiring. |
disable-archive-logs | Disable archive logging to save disk space. Archive logs are not necessary in development. |
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.