Data pump command import exclude
impdp system/Admin123 directory=exp_dir dumpfile=exp_dump.dmp logfile=exp_dump.log schemas=scott exclude=TABLE:\”IN \(\’EMP\’,\’DEPT\’\)\”
No comments yet
Mohamed Azar Blog's
Mohamed Azar
Database Administrator, Blogger, Contributor
Mohamed Azar twitt
Error: Please make sure the Twitter account is public.
Calendar
-
Recent Posts
- txkCfgUtlfileDir.sh directory does not exist
- Error: loading jvm.dll while install SAP IQ 16.1
- Backup encryption
- postgresql \i import sql file permission denied
- java.lang.RuntimeException: Prerequisite check “CheckActiveFilesAndExecutables” failed
- EBS Apache Log4J Vulnerabilities
- Invoice validation pending standby
- ORA-29024: Certificate validation failure
- Unable to connect to the mail account. Check the host, user name, password and connection security
- Database frequently stop connecting after upgrade 19c
Archives
- April 2022 (1)
- March 2022 (2)
- January 2022 (2)
- December 2021 (1)
- June 2021 (2)
- February 2021 (2)
- January 2021 (1)
- December 2020 (2)
- November 2020 (6)
- October 2020 (3)
- September 2020 (2)
- August 2020 (1)
- July 2020 (1)
- June 2020 (2)
- May 2020 (2)
- April 2020 (1)
- March 2020 (1)
- February 2020 (1)
- January 2020 (1)
- December 2019 (6)
- November 2019 (2)
- September 2019 (2)
- August 2019 (1)
- July 2019 (15)
- June 2019 (4)
- May 2019 (1)
- April 2019 (1)
- March 2019 (1)
- February 2019 (3)
- January 2019 (4)
- December 2018 (7)
- November 2018 (1)
- October 2018 (7)
- September 2018 (9)
- March 2018 (2)
- February 2018 (2)
- January 2018 (20)
- December 2017 (1)
- November 2017 (1)
- September 2017 (3)
- June 2017 (1)
- April 2017 (1)
- February 2017 (2)
- November 2016 (3)
- October 2016 (1)
- February 2016 (6)
- November 2015 (2)
- October 2015 (7)
- September 2015 (3)
- August 2015 (4)
- July 2015 (3)
- March 2015 (1)
- February 2015 (4)
- December 2014 (3)
- September 2014 (1)
- August 2014 (3)
- July 2014 (7)
- June 2014 (2)
- January 2014 (4)
- December 2013 (2)
- September 2013 (1)
- May 2013 (1)
- April 2013 (5)
- March 2013 (4)
- February 2013 (9)
- January 2013 (9)
- November 2012 (6)
- October 2012 (3)
- September 2012 (2)
- August 2012 (1)
- July 2012 (2)
- June 2012 (1)
- May 2012 (5)
- April 2012 (3)
- March 2012 (8)
- February 2012 (11)
- January 2012 (1)
- December 2011 (2)
- November 2011 (3)
- October 2011 (13)
- September 2011 (5)
- August 2011 (1)
- July 2011 (6)
- June 2011 (6)
- May 2011 (3)
- April 2011 (2)
- March 2011 (4)
- February 2011 (2)
- January 2011 (9)
- December 2010 (8)
- November 2010 (10)
- October 2010 (8)
- September 2010 (4)
- August 2010 (5)
- June 2010 (6)
- May 2010 (9)
- April 2010 (11)
- March 2010 (6)
- February 2010 (3)
- January 2010 (5)
- December 2009 (9)
- November 2009 (7)
Blog Stats
- 1,438,727 hits
Recent Comments
Abdulwajid on Error: loading jvm.dll while i… 
ashniazi8 on ORA-01552: cannot use system r… Abdul Wajid Khan on EBS Apache Log4J Vulnerab… 
Pedro Lopes on Database Security Assessment… 
Mohamed Azar on Remove this file if there is n… Categories
- 12c (2)
- Administration (95)
- Backup & Recovery (41)
- Book Review (9)
- Datapump (17)
- EBS (90)
- Flashback (9)
- Linux (19)
- Magazine (4)
- Multitenant (3)
- Products Released (2)
- RAC & ASM (25)
- Scripts (3)
- Security (12)
- Support ID (3)
- Uncategorized (86)
- Videos (4)
Blogroll
Mohamed Azar
DBA 