HOW TO REFRESH SCHEMA USING EXPDP/IMPDP || ORACLE 12C || EXPDP IMPDP UTILITY || DBA FROM INDIA
Автор: DBA FROM INDIA
Загружено: 2022-06-30
Просмотров: 5148
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
