import with parameter rows = n
No rows selected when query on tables but OEM | SCHEMA | TABLE shows there are millions rows counted and tablespace is up to 97% .
How do I reclaim space on tablespace ?
Thank you
Export:
full = y
direct = y
buffer = 1024
log = c:\export_struc_norows.log
grants = y
indexes = y
rows = n
constraints = y
triggers = y
feedback = 100000
Import:
full = y
buffer = 1024
log = c:\import_struc_norows.log
rows = n
ignore = y
indexes = y
constraints = y
grants = y
feedback=100000
full = y
buffer = 1024
log = c:\install\import_struc_norows.log
rows = n
ignore = y