ORA-01220: file based sort illegal before database is open
                                                 Last update (2013-07-31 13:47:33)
                                                                                                                   Date added (2013-07-31 13:46:08)

Summary
During the Duplicate of an Oracle9i database i get the message:
ORA-01220: file based sort illegal before database is open
Workaround: Set at the AUXILIARY init.ora file the following parameters:
sort_area_retained_size = 256000
workarea_size_policy = AUTO
pga_aggregate_target = 1000M
Reviews
Filters
Search