Skip to Main Content
  • Questions

  • Cant we take a backup of datafile using expdp y ??

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, sai.

Asked: August 29, 2017 - 1:58 pm UTC

Last updated: August 29, 2017 - 4:30 pm UTC

Version: 12.2.0.1.0

Viewed 1000+ times

You Asked

hi,

can not we take a backup of datafile using expdp and impdp ??

can we take a backup of schema in rman ??


and Chris said...

If you mean:

"Can we backup a specific data file using data pump export?"

The answer's no. You can export a tablespace and its data files. But if the tablespace has > 1 data file, you'll get the data from all of them.

http://docs.oracle.com/database/122/SUTIL/oracle-data-pump-export-utility.htm#SUTIL826

and

"Can RMAN backup all the objects from just one schema?"

Again, the answer's no. You can get close if your tablespace(s) only contain objects from one user. And you have no PL/SQL, views or other (non-data) code in the schema

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:897900400346833978

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database