RE: Enable novalidate contains after import?

Thanks.

I've had a check on a couple of tables using what turned up in longops. 10 full scans for a table with a single column pk constraint and 7 further not null constraints. I think that should make 9 full scans in total, if I've read your reply and blog post correctly?

I don't have any unique constraints ts on the table, and all indexes were precreated by the data import. The constraints are being created at the end with a norows dump file and everything possible set to N on the imp, except for constraints=Y.

They show=Y import was a disaster. 25mb of dump file created over 12 gb of output before I killed it. Most of the output is 'REM ' (2 Spaces after REM). For some reason. Another problem to figure out!

Cheers,
Norm.
--

Sent from my Android device with K-9 Mail. Please excuse my brevity.

--

http://www.freelists.org/webpage/oracle-l Received on Mon May 23 2016 - 15:56:18 CEST