Oracle Commands

Создание нового пользователя 

alter session set "_ORACLE_SCRIPT"=true;

CREATE USER user1 IDENTIFIED BY password;

 GRANT create session TO user1;

Удаление таблицы

DROP TABLE table1;

Создание Вьюшки

create view Andrei AS

select CUSTOMER_FIRSTNAME, CUSTOMER_ID from CUSTOMER where CUSTOMER_FIRSTNAME = 'Andrei';

Посмотреть ServiceName

select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
ORCLCDB.LOCALDOMAIN

Посмотреть SID

select name from v$database;

NAME
---------
ORCLCDB

Stop

shutdown immediate;

Посмотреть TABLESPACE

SELECT tablespace_name, file_name, status, bytes
FROM dba_data_files
WHERE tablespace_name LIKE '%'
ORDER BY tablespace_name, file_name
/

Пример создания TableSpace

CREATE TABLESPACE TS_DM DATAFILE '/mnt/db/oradata/DOCORA/TS_DM.dbf' SIZE 1024M;