Hi Manish, thank you for this video. you explained well the functions of those command and not letting us copy and execute without knowing what is the uses for each. you gained a sub from me.
Hi Manish , iam new to the oracle DBA field and your videos are really helpful for the beginner.....and easy to understand...thank you ..for this ,,,thumbs up :)
8 ปีที่แล้ว +1
thank you manish, you're great ! i've followed you everywhere to learn more Oracle, hope to see you once in my life :)
Thanks a lot for this lovely comment. I am really glad for your love and support.
8 ปีที่แล้ว
Can you guide me how to expdp/impdp for multi files dmp multi tables ? ex: table1.dmp - table 1 only table2.dmp - table 2 only all in one command, each dmp for every table I want to exp/imp
Hi manish. first at all thank u From Colombia for this tutorials. I have one question. If I have a .dmp bk that was taken from the exp command (not expdp) , I wanna know the differences with expdp and also if this contains all data from db. Specially When I see the log file I can see clearly that the tables were exported with synonyms,views,store procedures..etc.. but I cant see the table spaces and schemes My concern is that right now Im implementing a test envoirament from scrath (I just isntall oracle following you tutorial) and they ask me to restore this .dmp backup in this new server. I saw the .bat file that they use for the backup and they use exp tool with this syntax: C:\app\user\product\11.2.0\dbhome_1\BIN\EXP USERID=User\pwd@instance file=D:\bkoracle\oracle001_xxx.DMP log=D:\bkoracle\oracle001_xxx.LOG buffer=2000000 owner:User can I restore using expdp tool and all the db will be complete ?
Hello Manish Thank u so much for your awesome tutorial I have an issue export full database using #expdp export data pump utility then i got an error like operation generated oracle error 12154 please help me how can i find my error. Thank U
Hi Manish, I am not sure if I can ask this for you but it would be really grateful if you have any answer of my question. I did full database using expdp following your description and got some error like this : ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 1 with process name "DW00" prematurely terminated ORA-31671: Worker process DW00 had an unhandled exception. ORA-00600: internal error code, arguments: [qctchr : bfl], [400], [100], [1], [846], [1], [0], [], [], [], [], [] ORA-06512: at "SYS.KUPW$WORKER", line 1714 ORA-06512: at line 2
Hi Manish , im using 12c when im going to Export getting this error ORA-12154: TNS:could not resolve the connect identifier specified.... please advice me
I am getting below issue after running : expdp hybris63/hybris64@XE DIRECTORY=orcl_obj DUMPFILE=orclfull.dmp LOGFILE=full_exp.log FULL=YES; UDE-12545: operation generated ORACLE error 12545 ORA-12545: Connect failed because target host or object does not exist
I got this message: Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", line 536 ORA-29283: invalid file operation How to solve it?
I am trying to run export (expdp) in a Windows environment, and I am getting these errors: ORA-39002: invalid operation dbms_datapump.get_status(178...) ORA-39002: invalid operation ORA-39070: unable to open the log file. ORA-29283: invalid file opertion ORA-06512: at "SYS.UTL_FILE", line 536 ORA-29283: invalid file operation
I got a TNS error : UDE-12170: operation generated ORACLE error 12170 ORA-12170: TNS:Connect timeout occurred To solve this, just remove the '@ORCL' part from the expdp (when working on the dbserver)
C:\>expdp system/admin1234@XE DIRECTORY=sam DUMPFILE=xefull.dmp LOGFILE=samxe.log FULL=YES; LRM-00105: 'YES;' is not a legal Boolean for 'full' any idea?
This is very crystal clear i like the speed of this tutorial.
The description part which is a side note is a good approach.
Short and concise. I love the way you presented the export action! I learned more during this video then in the last 2 hours, thanks a lot!
This is very clear man. very straight.
Thank you so much.
Hi Manish, thank you for this video.
you explained well the functions of those command and not letting us copy and execute without knowing what is the uses for each. you gained a sub from me.
Thank you so much for the video I have been looking for this information for a week.
Why can't every tutorial be at this pace? Bravo
Thank you Manish for sharing this in easy and clear way.
Hi Manish , iam new to the oracle DBA field and your videos are really helpful for the beginner.....and easy to understand...thank you ..for this ,,,thumbs up :)
thank you manish, you're great ! i've followed you everywhere to learn more Oracle, hope to see you once in my life :)
Thanks a lot for this lovely comment. I am really glad for your love and support.
Can you guide me how to expdp/impdp for multi files dmp multi tables ?
ex: table1.dmp - table 1 only
table2.dmp - table 2 only
all in one command, each dmp for every table I want to exp/imp
Big help. Thanks!
Thanks, Started following your tutorials
Loved it !!! Thanks for sharing ...
Thank u Manish for very informative series of videos
+Akbar Yuldoshev It's a huge pleasure that you find my videos helpful. Please do make sure to like and share with your friends.
Thank you Manish...great vid...your help is very much appreciated.
you are best tutor
sir gant access to HR user is necessary . cant we export using sys user ?
Hi thanks Manish ! To create a dmp file for .5 TB using expdp. how much time would it take using parallel option ?? Do I need not to log archived?
You have really explained in very elegant way :) Thank you.
thank you very much that was very helpfull
MUITO OBRIGADO!!!! VC É DEMAIS. MUITO SHOW.
Useful tutorial
I'm glad you found it useful! If you could quickly master any advanced SQL skill, what would it be and why? 😊
Hi manish,
could you please share the video for database refrsh incuding concept of refresh?
Thanks,
it’s the same export dump file?
Manish, can you post some tutorial on how to write procedures in Oracle ?
Hi Manish.
Who provide the memory for exp and imp? If any bg process then let me know.
SGA Provide
Can you create video for expdp and impdp for pluggable database only, as I am facing difficulty
You are gem, my dear friend, thanks a lot
Thank you Manish
is it for sql developer also
Thx you very much your video very very help full for me :D
absolutely beautiful.
Thank you so much
Manish can you Make same video with pluggable database as i am getting error using expdp with pluggable database
nice explanation..happy :):)
Hi manish. first at all thank u From Colombia for this tutorials.
I have one question. If I have a .dmp bk that was taken from the exp command (not expdp) , I wanna know the differences with expdp and also if this contains all data from db. Specially When I see the log file I can see clearly that the tables were exported with synonyms,views,store procedures..etc.. but I cant see the table spaces and schemes
My concern is that right now Im implementing a test envoirament from scrath (I just isntall oracle following you tutorial) and they ask me to restore this .dmp backup in this new server. I saw the .bat file that they use for the backup and they use exp tool with this syntax:
C:\app\user\product\11.2.0\dbhome_1\BIN\EXP USERID=User\pwd@instance file=D:\bkoracle\oracle001_xxx.DMP log=D:\bkoracle\oracle001_xxx.LOG buffer=2000000 owner:User
can I restore using expdp tool and all the db will be complete ?
Hello Manish Thank u so much for your awesome tutorial
I have an issue export full database using #expdp export data pump utility then i got an error like operation generated oracle error 12154 please help me how can i find my error. Thank U
Hi Manish, I am not sure if I can ask this for you but it would be really grateful if you have any answer of my question. I did full database using expdp following your description and got some error like this :
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-00600: internal error code, arguments: [qctchr : bfl], [400], [100], [1], [846], [1], [0], [], [], [], [], []
ORA-06512: at "SYS.KUPW$WORKER", line 1714
ORA-06512: at line 2
Hi Manish , im using 12c when im going to Export getting this error ORA-12154: TNS:could not resolve the connect identifier specified.... please advice me
Check the name of your global_variable by using the command:
select * from global_name;
and use it in place of orcl in hr/hr@orcl.
LRM-00105: 'YES;' is not a legal Boolean for 'full'
Everything is as per the video but why this error is coming ?
Try putting FULL=YES after log in credentials
sir ji dba 2 ka RMAN,FLASHBACK, DATAGAURD PERFORMANCE TUNING bhi tutorial BANAO PLEASE BRO
good tutorial
I am getting below issue after running :
expdp hybris63/hybris64@XE DIRECTORY=orcl_obj DUMPFILE=orclfull.dmp LOGFILE=full_exp.log FULL=YES;
UDE-12545: operation generated ORACLE error 12545
ORA-12545: Connect failed because target host or object does not exist
I got this message:
Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
How to solve it?
how import please full
Thanks
I am trying to run export (expdp) in a Windows environment, and I am getting these errors:
ORA-39002: invalid operation
dbms_datapump.get_status(178...)
ORA-39002: invalid operation
ORA-39070: unable to open the log file.
ORA-29283: invalid file opertion
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
same issue, how did you resolve it?
I got a
TNS error : UDE-12170: operation generated ORACLE error 12170
ORA-12170: TNS:Connect timeout occurred
To solve this, just remove the '@ORCL' part from the expdp (when working on the dbserver)
its says internal error
C:\>expdp system/admin1234@XE DIRECTORY=sam DUMPFILE=xefull.dmp LOGFILE=samxe.log FULL=YES;
LRM-00105: 'YES;' is not a legal Boolean for 'full'
any idea?
I'm facing the same problem as like Sayma. @Manish, could you please help us here? Thanks in advance!
try C:\>expdp user/password@host/servicename full=Y DIRECTORY=orcl_full DUMPFILE=orclfull.dmp LOGFILE=full_exp.log;
Yo man good
Import video.
Yes pls do make 'em ...need whole db refresh video,if possible.
good tutorial,
I have this inconvenience "ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS"
(y)
ayman alsayed Thanks for the thumbs up :-) hope you are enjoying my videos. Your feedback means a lot to me.
Manish Sharma and i'm so happy following u