oracle 12c pl/sql语言,一点Oracle 12c用到的PL/SQL语句

查看数据库版本号

PL/SQL下

Select * from v$version;

APEX卸载前的步骤

alter session set “_oracle_script”=true;

使PDB处于OPEN状态

进入PL/SQL

alter session set container=pdbapex;

Show_name;

更改PDB状态为OPEN

alter pluggable database apexpdb open readwrite;

使PDB处于永开状态

CREATE TRIGGER open_pdbs

AFTER STARTUP ON DATABASE

BEGIN

EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN';

END open_pdbs;

/

查看PDB状态

SELECT name,open_mode FROM v$pdbs;

创建表空间APEX_01 和临时表空间 TEMP_01

创建表空间

CREATE TABLESPACE APEX_01 logging

DATAFILE'C:/app/sanyc/oradata/sanyc/pdbapex/APEX_01.dbf'

SIZE 100M

AUTOEXTEND ON NEXT 100M

MAXSIZE 1000M;

创建临时表空间

create temporary tablespace TEMP_01

tempfile 'C:/app/sanyc/oradata/TEMP_01.dbf'

size 5m

autoextend on next 2m

maxsize 20m;

关闭PDB

alter pluggable database pdbapex close;

删除PDB

drop pluggable database pdbapex;

级联的

drop pluggable database pdbapex includingdatafiles;

创建PDB

CREATE PLUGGABLE DATABASE pdbapex

ADMIN USER sys

IDENTIFIED BY Oracle12c

STORAGE

(MAXSIZE 1G

MAX_SHARED_TEMP_SIZE 100M)

DEFAULT TABLESPACE APEX_01

DATAFILE'C:/app/sanyc/oradata/sanyc/pdbapex/APEX_01.dbf’

SIZE 100M

AUTOEXTEND ON;

工作队列进程的设置

SELECT VALUE FROMv$parameter WHERE NAME = 'job_queue_processes'

ALTER SYSTEM SETJOB_QUEUE_PROCESSES =