It’s important that you periodically export your Oracle database so that you don’t lose your work during the semester. This document describes how to do it.
Step 1: Execute the CATALOG.SQL Script
This script is ONLY EXECTUED ONCE. After executing the script once, you will then be able to export as often as you want.
Get a DOS command prompt.
Go to the following directory, where you install the orcale rdbms. for example
cd c:\oracle\ora81\rdbms\admin
Get into sqlplus using the “SYS” user:
sqlplus sys/change_on_install@cs325
Execute the catalog.sql database script:
@catalog.sql
Wait for about 5 minutes for the script to complete.
Step 2: Run the export command pressing enter at each prompt to select defaults.
Note the userid/password I’m providing in this example may not be the userid and password you want to use:
exp scott/tiger@cs325
OR
exp sys@repc_brd as sys dba/sys
You should verify at the end of the export that the tables YOU created for your project are actually being exported by observing the “exporting table” information that appears in the export log. In this example, there were four tables exported: BONUS, DEPT, EMP, and SALGRADE.
[Note: If this article helps you, don’t forget to share with your friends. Its help them also.]
No comments:
Post a Comment