Oracle Export Data and Import Data using DataPump
Вставка
- Опубліковано 11 сер 2017
- Steps to Import and Export Table
Step 1: Create Directory
Step 2: Grant Read and Write Permission to Directory
Step 3: GRANT ROLL DATAPUMP_EXP_FULL_DATABASE to user
Step 04: Use EXPDP and IMPDP to Export and Import data
Great job men
Thanks! keep learning.
kya baat ai bilal ji!
thank you.
sir agr mere pas 2 database hain db1 or db2
mene db1 ka all data export karlia ab me db1 ka all data db2 me import karna hy tw uske lia hm kia commond likhyen gyen??? or kon kon c privilages dyen gyen??? plz guide me
Hi all, Plz help me to resolve this error
C:\Users\thone>sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Wed Aug 24 15:50:27 2022
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn sys as sysdba
Enter password:
Connected.
SQL> alter session set container = pdborcl;
alter session set container = pdborcl
*
ERROR at line 1:
ORA-02248: invalid option for ALTER SESSION
conn sys as sysdba
Enter password:
Connected.
and then write command to display pluggable database:
show pdbs;