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