Versions Compared

Old Version 1

changes.mady.by.user Chieko Sugizaki

Saved on

compared with

New Version Current

changes.mady.by.user Robert Andelin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space FUNCTDEV and version SVC2025.3

...

Code Block
ALTER SESSION SET CONTAINER=XEPDB1;

CREATE TEMPORARY TABLESPACE "EM_TEMP" TEMPFILE 'EM_TEMP.ORA' SIZE 10M REUSE AUTOEXTEND ON NEXT 20M;
CREATE TABLESPACE "EM_DATA"  DATAFILE 'EM_DATA.ORA' SIZE 50M REUSE AUTOEXTEND ON NEXT 100M;

CREATE USER "EM"  PROFILE "DEFAULT"
    IDENTIFIED BY "em" DEFAULT TABLESPACE "EM_DATA"
    TEMPORARY TABLESPACE "EM_TEMP"
    QUOTA UNLIMITED
    ON "EM_DATA"
    ACCOUNT UNLOCK;

GRANT ALL PRIVILEGES TO EM;

CONNECT em/em@XEPDB1;

PostgreSQL

If you are using PostgreSQL on the same host:

psql -U <username> -d <database_name> -f postgres_db.sql

If you are using PostgreSQL on a different host:

psql -h <host> -p <port> -U <username> -d <database_name> -f postgres_db.sql