|
-
 Originally Posted by davey23uk
yeah, do some investigation and provide some analysis
We have table called ABC_TEXT with one columns as "MSG" and the data type was LONG I converted the LONG column to CLOB as given below.
Alter table ABC_TEXT modify msg clob;
Number of row were equal after modification i.e. "4500000" appox.
When I am exporting this table it took 3.25 Hours. That is my problem and export command is given below
exp system@abcvora1 tables=abc_TExT Direct=y file=C:\ABS.bak
kindly advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|