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 import directory to 775.
Delete the data of the table from SE14 before importing.
Procedure :
Start the brtools with command $ brtools


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
Always count the table rows before and after the import to table.
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 import directory to 775.
Delete the data of the table from SE14 before importing.
Procedure :
Start the brtools with command $ brtools
- Choose the Segment Management of Choice 3

- For the Table Export choose the option 4

- Provide the Dump file location with data dump
- Press Continue to check the import option.
- Again Press Continue and change the option 4 - replace and 7 - force
- Press Continue to start the import
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
Always count the table rows before and after the import to table.
No comments:
Post a Comment