I might just mention that it's the "DBA role", not the 'DBA privilege(s)'.
There's a difference between roles and privileges. And you're still
ignoring the fact that, whatever your privileges, the 'create tablespace'
commands that the import process tries to perform will require data files to
be created in exactly the same location/directories as the original
database. So possessing the DBA role is *not* going to be 'all you need'.
HJR
--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================
"Hassan Ayub" <hassan_ayub_at_yahoo.com> wrote in message
news:1df2b71.0202060636.3d0a4320_at_posting.google.com...
> Hi there,
> All you need is to have a user having DBA priveliges and the rest
> will be taken care by the Oracle import utility. You can either create
> a new user with dba privileges or import the whole database in the
> existing user with dba privileges and all the tables plus data plus
> constraints, objects will be successfully imported.
>
> Good luck!!
>
>
> Hassan
Received on Wed Feb 06 2002 - 12:49:50 CST
