Pre-Requisite :
Login with os user ora<sid> or oracle.
Create a directory, which have access of oracle or ora<sid> user.
Change the permission of the table export directory to 775.
Procedure :
Start the brtools with command $ brtools
- Choose the Segment Management of Choice 3

- For the Table Export choose the option 3

- Provide the Table Name and Export dump directory location with the option 6 and 7 respectively.

- Press Continue to check the export option.

- Again Press Continue to start the export of the table and will create the export file with <file_name>.dmp

Suggestion :
Always make sure that you have updated version of brtools available in your system.
Do not manually set the permission of brtools executable.
Before import or export activity always make sure that you have full backup of the system
No comments:
Post a Comment