Re: export, drop, import is the way?

stephan laue <stephan.laue_at_pdb.sbs.de> wrote:

]Could anyone help me with export / import ?
]
]Situation:
]a large table with many extents.
]I plan to export and import this table, so that i get a table with only
]one extent.
]
]Question: is it enough to export, than drop this table and import it
]back in the user's scheme ?
]
]thank's for your help!
]Stephan

As well as the other advice posted, you might want to truncate the table before you drop it (saves time and redo logs).

-- 
 ,-,_|\   George Dau,                                             __
/    * \  Unix (Solaris, DEC Unix, Linux), NT, Oracle, Internet. (OO)
\_,--\_/  Home: gedau_at_pobox.com          Work: gedau_at_mim.com.au ( \/ )
      v   WWW:  http://pobox.com/~gedau                          W--W

Food for spambots: 
contact_at_robo.lostvegas.com osm_at_online-group.com
kittycat_at_speedmatrix.com sharon822_at_gracefully.com
postmaster_at_ix.netcom.com lisa_at_ix.netcom.com
scoop_at_skynet.net.au wayne_at_inreach.com
webmaster_at_arabicnews.com macs_at_lostvegas.com
editors_at_arabicnews.com comments_at_arabicnews.com
subscription_at_arabicnews.com ;-) imsco_at_acceptcards.com
upstart_9_at_hotmail.com