Oracle Data Import and Export

I am the new Oracle, and that I need to learn more about it. But as your know, here are the company, isn't the school, you just stady by yourself, and no one can help you a lots.

So, for the work, I need to learn how to backup our databases.

Do it like this, you want to backup all of the database files and you can do it like that:

EXPDP Username/password schemas=xxx dumpfile=xxx.dump directory=exp_dir

If you want to backup one time data and one table, you can add the condition to the order, for example:

EXPDP username/password dumpfil=xxx directory=exp_dir tables=table01 query=\ "" where time\<to_char\ (\ "2014\-10\-01 \ "," yyyy\-mm\-dd "\) \" "

Imput the data to the database,

IMPDP username/password schemas=xxx directory=exp_dir dumpfile=xxx.dump logfile=xxx.log

Oracle Data Import and Export