Re: IMPORT - how many passes?

> I appreciate your patience and help. Let me try to understand what
> you're saying -

No problem.

> Are you saying that I can create an Oracle 9.2 database, drop all the
> users except for sys and system, and then simply run import with full=y
> using a dmp file that's a full export from 8.1.6?
>
> This sounds too easy.

It's pretty much that easy.

> For one, the 9.2 database is created with a locally managed system
> tablespace, which means that dictionary managed tablespaces are
> verboten. I've looked at the output of a show=y full=y import and it
> tries (and fails) to create all the tablespaces as dictionary managed.
>
> Can I just precreate the tablespaces? Or is there more to it than that?

You can still create DMTs in 9i. But you have to specify that it is a DMT. The default is LMT. What is probably failing is that you are specifying default storage parameters in the CREATE TABLESPACE command without specifying that it is also a DMT. So I'd precreate the tablespaces. Even though the objects were in a DMT in the 8i database, they can live in a new LMT in the 9i database. That doesn't matter.

Yes...it's pretty much that easy. You may have a few more "wrinkles" to sort out, like making sure you have enough UNDO or rollback space to import a large table.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"