This commend to IMPDP EXCLUDE TABLES

expdp username/password DIRECTORY=my_dir DUMPFILE=exp_tab.dmp LOGFILE=exp_tab.log SCHEMAS=scott
EXCLUDE=TABLE:\IN \(\EMP\, \DEP\\)\



What shall i do IF i need to Exclud TABLES,procedure,function IN the same time



Your support shall be highly appreciated.

expdp username/password DIRECTORY=my_dir DUMPFILE=exp_tab.dmp LOGFILE=exp_tab.log SCHEMAS=scott EXCLUDE=PROCEDURE,FUNCTION,TYPE,TRIGGER,INDEX

جزاكم الله خير اخى الحبيب
لدى استفسار اخر ما معنى كلمه REMAP فى هذا الكومند

impdp username/password REMAP_TABLESPACE
impdp username/password DIRECTORY=my_dir DUMPFILE=exp_tab.dmp LOGFILE=imp_tab.log REMAP_SCHEMA=
يعنى لو سمحت شرح لمعنى ال REMAP وهل هو ياتى فى ال imp command فقط ام ماذا؟

REMAP_SCHEMA is used to import schema objects in another schema like you export scott schema tables and want to import them into hr schema
it is used like this REMAP_SCHEMA=SCOTT:HR

hope this will help you

.....OK
BUT i want ask about .IF i can IMP these tables from SCOTT SCHEMA TO hr schem without REMAP
OR REAMP is mandatory in this COMMAND

please advice and revert

remap_schema is mandatory to import schema's objects in another schema

thanks alot for interesting
اخى الحبيب واضح انك لديل خبرة ما شاء الله
انا الان اعتبر فى بداية الطريق لل DBA..
اريد من حاضرتك الاشياء الذى اذا تعلمتها اعتبر good DBA
وهل الان المفروض ان اعرف كيف اعمل Stand By database

وجزاكم الله خير وبارك الله فيك.

Oracle Standby Database is one of the advanced installations in Oracle and I don't think you need it now.
you better now increase your experience in database backups and recoeries and exports , imports and database tuning till you got some experience then you can go forward to another level of oracle administration and installations like standby databse , replication and RAC.

I advice you to read many docs and join dba forums to see what dba probelms and how experts solve these problems

Thanks a lot my brother for your advice

Regarding to OS level UNIX AND LUINX, What do you recommend?
Best Regards

Thanks a lot my brother for your advice
Kindly could you tell me what is the best site or forum that I can browse to learn about DBA problems and how to solve them?
Regarding to OS level UNIX AND LUINX, What do you recommend?
Best Regards

try oracle technology forums and dba-village.com

thx alot WAZIRY for your good questions

and a BIG thx for our senior DBA AIRTIFA for his help in many of oracle subjects

GAZAKOM ALLAH kl KHER

THX

الاخ AIRTIFA

بالنسبة للموقع http://dba-village.com عندما ادخل علية وافتح بعض الخيارات يعطينى هذه الرسالة مع انى عملت ريجستر لليوزر والباسورد


وقد ارسلت لك الملف كى ترى الخطا

الرجاء النصيحه

username_pass.rar