Home > Oracle > Backup/export Oracle database tsn name

Backup/export Oracle database tsn name


Today I wanted to backup/export an Oracle database so that I can restore it to another computer. I am not a dba and most of my “dba” experience is related to SQL server. Long story short, after around 30 minutes of research I had to use the following syntax in the command prompt:

exp file=”C:\OracleBackups\Mydatabase201107221422.dmp full=yes

Make sure that the folder you are export to DOES exist. exp won’t create for.

It will then ask you to enter the username which must be in the following format username@tsnname (e.g. ahmed@XE) You need to use a username with sufficient privileges

Press enter and it will prompt you to enter your password.

Enter the password and you are set 🙂

When I restore/import the database I will update this post.

Cheers for now

Advertisements
Categories: Oracle Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: