Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help on exporting tables
Hi,
First, what sort of export have you make ?
Full export (exp FULL=y) ?
Table export (exp TABLES=tab1,tab2) ?
User export (exp OWNER=user1) ?
Have you test import with "GRANTS=N" flag ?
Best regards from Paris.
Khue Pham a écrit :
> Hi everyone:
>
> I am trying to export tables from one database and import them back to
> another. I have no problem with the exporting table ( or schema associates
> with an user ). However, when I import the tables to the new database then
> it complains about missing users and roles ( error ORA-01917 ). My question
> is:
>
> 1. How do I know who is associate with which tables ( in the source
> database )?
> 2. Can I export the users/roles that assoicate with the tables on the
> source database and import them to the destination database before I import
> the tables ?
> 3. In case I can not export the users/roles then what I should do to move
> tables from a database to another with the condition that all users
> associate to those tables are also be on the destination database?. I know
> how to do it manually but it is so painful to do so.
>
> All your helps are appreciated in advance.
>
> Please reply to Khue.Pham_at_Waterloo.NCR.COM
>
> Best regards,
>
> Khue Dinh Pham
--