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?

    Requires Free Membership to View

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 first published in July 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: