HOW TO REFRESH SCHEMA USING EXPDP/IMPDP || ORACLE 12C || EXPDP IMPDP UTILITY || DBA FROM INDIA

Hi There In this video I have tried to explain about the schema refresh activity using expdp impdp utility of oracle. Below are given steps. If you find this video helpful LIKE SHARE & SUBSCRIBE. PLAN ==== 1. CREATE TABLESPACE 2. CREATE AN USER 3. GIVE QUOTA TO THE USER ON THE TABLESPACE 4. IMPORT THE EPORT BACKUP TO THE NEW USER STEPS: ======== GET DDL: ======= select username,account_status from dba_users where username like '%TEST_02%'; Set pages 999; set long 90000; select dbms_metadata.get_ddl('USER','TEST_02') from dual; select file_name from dba_data_files where tablespace_name='USERS'; CREATE TABLESPACE: ================= create tablespace TESTUSER datafile '/u01/PROD/db_files/PROD/testuser1.dbf' size 50M; CREATE USER "TESTUSER" IDENTIFIED BY TESTUSER#123 DEFAULT TABLESPACE "TESTUSER" TEMPORARY TABLESPACE "TEMP"; ALTER USER TESTUSER QUOTA UNLIMITED ON TESTUSER; nohup impdp \'/ as sysdba\' directory=EXPDP dumpfile=TEST_02.dmp logfile=import_test_02_to_TESTUSER.log remap_schema=TEST_02:TESTUSER & #oracle #oracledba #oracledatabasetutorial #oracle12c #oracle19c #oracle11g