VPD Policy Implementation - ORACLE Database VPD policies Oracle CREATE TEST USERS in DB -- Owner schema for objects CREATE USER app_owner IDENTIFIED BY AppOwner#123 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON users; GRANT CREATE SESSION, CREATE TABLE, CREATE PROCEDURE, CREATE ANY CONTEXT TO app_owner; -- Test application user CREATE USER app_user IDENTIFIED BY AppUser#123 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; GRANT CREATE SESSION TO app_user; CONNECT TO USER CONN app_owner/AppOwner#123 CREATE THE SAMPLE TABLE AND DATA CREATE TABLE employees ( emp_id NUMBER PRIMARY KEY, emp_name VARCHAR2(100), department_id NUMBER, salary NUMBER ); INSERT TEST DATA INSERT INTO employees VALUES (1, 'John', 10, 1000); INSERT INTO employees VALUES (2, 'Mary', 20, 1200); INSERT INTO empl...
Check current directory pathes which are on the source database. SELECT directory_name, directory_path FROM dba_directories; create and grant permision to run expdp for the same location which you want to run the backup. CREATE OR REPLACE DIRECTORY DUMP_NEW_DIR AS '/BACKUP'; GRANT READ, WRITE ON DIRECTORY DUMP_NEW_DIR TO SYSTEM; before running the below command create a file in the directory and give permissions as follows, chmod -R 777 export.par vi export.par DIRECTORY=DUMP_NEW_DIR DUMPFILE=full_db_export_%U.dmp LOGFILE=export.log FULL=Y PARALLEL=2 run the command nohup to run this expdp without enteruptions. nohup expdp system/oracle123 parfile=export.par & check if any exp process are running on the database using below sql command. col owner_name format a12 col job_name format a25 col state format a15 col operation format a10 col job_mode format a12 select owner_name, job_name, operation, job...