Re: IMPORT - how many passes?

"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:3FA82C7D.22BFC8C_at_remove_spam.peasland.com...
> > 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.

Brian: I think the problem is rather that the OP has a locally-managed system tablespace, and in that case you *can't* create new DMTs, unless they are read only... which of course puts paid to the idea of doing an import into them. But whatever: the end result is the same -pre-create the tablespaces and then do the import.

Regards
HJR Received on Tue Nov 04 2003 - 17:30:52 CST