Create tables in a schema

create_table.bat

@echo off
setlocal enableextensions

pushd "%~p1"

set FILENAME="%~n1"

echo @%FILENAME% exit; | sqlplus -l -s /nolog

popd
pause

login.sql

SET ESCAPE ON
SET SERVEROUTPUT ON SIZE UNLIMITED
SET LINESIZE 32767
SET VERIFY OFF FEEDBACK OFF ECHO OFF
SET NEWPAGE 0 PAGESIZE 0 TRIMSPOOL ON HEADING OFF

-- ignore existing tables
WHENEVER SQLERROR CONTINUE

BEGIN
  DBMS_OUTPUT.PUT_LINE('----------------------------------------------------------------------------');
  DBMS_OUTPUT.PUT_LINE('Creating tables in ' || LOWER('&_user') || '@&_CONNECT_IDENTIFIER');
  DBMS_OUTPUT.PUT_LINE('----------------------------------------------------------------------------');
END;
/

@@ users;

test.sql

CONNECT /@DB.world;  -- uses wallet authentication to database

CREATE TABLE abc123 (
  n INTEGER
);
GRANT SELECT, INSERT, UPDATE, DELETE ON abc123 TO &FOO_USERS;

users.sql

-- user groups
DEFINE FOO_USERS = "andy, jimmy"
DEFINE BAR_USERS = "kylie"