Pages

Thursday, November 27, 2008

ORACLE: Create Backup/Export db backup

>exp userName_FromToCopyDate/Password@Orcl
>Enter array Fetch buffer size:xxxx> PRESS ENTER
>Export file: EXPDAT.DMP> ENTER FILE NAME.DMP
>(2)U, or (3)T: (2)U> Press Enter to export full user Information or press 3 and enter for just export user tables
>Export grants : yes>press enter
Export table date (yes/no): yes >press enter
compress extents (yes/no): yes >press enter
Export terminated Successfully with warnings.

No comments: