Oracle

Создание пользователя и раздача привилегий
CREATE USER VIRT_CBS2 IDENTIFIED BY VIRT_CBS2;
GRANT CONNECT, RESOURCE TO VIRT_CBS2;

Создание директории, экспорт и импорт
CREATE DIRECTORY DUMPS AS '/opt/oracle/dumps';
expdp system/system DIRECTORY=DUMPS DUMPFILE=USER_SCHEMA_PLATFORM.DMP LOGFILE=USER_SCHEMA_PLATFORM.EXPDP.LOG SCHEMAS=PLATFORM
impdp system/system DIRECTORY=DUMPS DUMPFILE=USER_SCHEMA_PLATFORM.DMP LOGFILE=USER_SCHEMA_PLATFORM.IMPDP.LOG2 SCHEMAS=PLATFORM REMAP_SCHEMA=PLATFORM:VIRTUAL1 TRANSFORM=OID:N

Импорт с максимальным количеством параметров
impdp system/system DIRECTORY=DP DUMPFILE=USER_SCHEMAS.DMP LOGFILE=SYSFLEXTERA_DEMO.IMPDP.LOG SCHEMAS=SYSFLEXTERA,DEMO REMAP_SCHEMA=SYSFLEXTERA:TAX1 REMAP_TABLESPACE=USERS1:USERS TRANSFORM=OID:N TABLE_EXISTS_ACTION=REPLACE

Размер схемы
SELECT SUM(BYTES/1024/1024) FROM DBA_SEGMENTS WHERE  OWNER = 'PLATFORM' AND (SEGMENT_TYPE LIKE 'TABLE%' OR SEGMENT_TYPE  LIKE 'LOB%')

Размер всех схем
SELECT OWNER AS SCHEMA, TRUNC(SUM(BYTES)/1024/1024) AS MB FROM DBA_EXTENTS GROUP BY OWNER ORDER BY SCHEMA ASC, MB DESC;

#ВСТАВКА ИЗ OMEGA7.PDOCBUFERRORSTACK@ST7
INSERT INTO "LOAN_ADMWS"."PDOCBUFERRORSTACK" SELECT * FROM OMEGA7.PDOCBUFERRORSTACK@ST7

Использование эскпорта с текущей датой в имени файла и лога
expdp system/system DIRECTORY=DP DUMPFILE=DEPOSIT_BACK_`date +%F`.DMP LOGFILE=DEPOSIT_BACK_`date +%F`.EXPDP.LOG SCHEMAS=DEPOSIT_BACK