Database Utilities (MOSC)

MOSC Banner

import with parameter rows = n

edited Jun 27, 2012 2:56PM in Database Utilities (MOSC) 4 commentsAnswered
I export / import by using the following parameters: ( rows = n ( no data ).

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center