AAA

tar -czvf aaa_241014_v1.tar.gz tcdn_moi_adan_241014_v1.dmp

tar -xzvf aaa_241014_v1.tar.gz

h1. https://www.howtogeek.com/248780/how-to-compress-and-extract-files-using-the-tar-command-on-linux/

h1. impdp
Trường hợp dump lại toàn bộ - xóa thủ công không xóa schema (không có quyền)
-- xóa bảng và thủ tục

alter session set current_schema=aaa_tcdn;
BEGIN
FOR r IN (
SELECT table_name
FROM all_tables
WHERE owner = 'AAA_TCDN'
) LOOP
EXECUTE IMMEDIATE 'DROP TABLE "AAA_TCDN"."' || r.table_name || '" CASCADE CONSTRAINTS';
END LOOP;
END;
/
BEGIN
FOR r IN (
SELECT object_name, object_type
FROM all_objects
WHERE owner = 'AAA_TCDN'
AND object_type IN ('PROCEDURE', 'FUNCTION', 'PACKAGE', 'PACKAGE BODY',
'VIEW', 'TRIGGER', 'SEQUENCE', 'SYNONYM')
) LOOP
EXECUTE IMMEDIATE 'DROP ' || r.object_type || ' "AAA_TCDN"."' || r.object_name || '"';
END LOOP;
END;