Re: Moving data from 8.1.6.3 to another 8.1.7 machine

"Lauren Buchholz" <lauren_at_myself.com> wrote in message news:25c6b7f0.0109161236.e56c332_at_posting.google.com...
> Hi, I don't claim to be a DBA, but I got some oracle stuff dumped on
> me and am having some problems. I have an instance running on a
> server running 8.1.6.3 right now, and I need to move a dupliacte of
> the data onto a a second machine that is running 8.1.7. I have
> created the instaces and the tablespaces on the new machine, and done
> a full system level export with a inclevel=complete on the source
> database, but when I try and import, I am getting object creation
> errors for the tables that belong to non-system schemas. I do not
> know the passwords of all of the schemas on this box, and have not
> seen a way to get the import to create the schema with the same
> uid/pwd as the source. IS this possible, or is there another way to
> get the same nt result?
>
> Regards...

A full database export does contain 'create user' statements, so all your non-system schemas will be created. There is *no* need to know passwords. So (and next time please don't try to be vague) which *exact* 'object creation errors'
and ...
did you create a second rollback segment in the tablespace system? If not, that probably explains *all* your errors. Do you run with the option ignore=y, as you already seem to have pre-created tablespaces?

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Sun Sep 16 2001 - 16:28:18 CDT