Problem solve Get help with specific problems with your technologies, process and projects.

Code to back up a tablespace

Brian Peasland explains how to use the export utility to create a logical backup of a table.

I am new to Oracle administration. I can't get the exact syntax of backing up only one user table. Can you provide a code snippet to achieve this?
Oracle's unit of backup is the tablespace, not the table. There is no command in Oracle to back up just a table. You'll most likely have to back up the tablespace that contains that table, but you'll get everything in that tablespace.

You can create a logical backup of a table if you want. In my opinion, this is not a true backup, but it does get...

a copy of the table and its contents. The tool to use is Oracle's export utility. The following command will show an example of exporting the table to a dump file:

exp userid=system/manager file=my_table.dmp tables=owner.my_table

Keep in mind that this is a logical backup and not a physical backup.

This was last published in July 2004

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.