RE: Import one table

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Wed, 23 Mar 2005 10:12:03 -0500
Message-ID: <005601c52fba$ab9b9590$8459000a@vttaxnet.tax.state.vt.us>

Do the import as system and qualify the table_name with the schema_owner. That should do it. Or, you could give import full database privileges to the schema owner. That will work too.

Ruth

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Smith, Ron L. Sent: Tuesday, March 22, 2005 8:04 PM
To: oracle-l_at_freelists.org
Subject: Import one table

This has been a problem a couple of times and I have not found an answer.
I have a full database export taken with the SYSTEM account. I need to restore 1 table from 1 schema, not owned by SYSTEM. If I run the import as the schema owner, it fails because the schema owner did not create the export.
If I run the import as SYSTEM, I cannot specify the schema and the table name at the same time.

What am I missing?

Thanks!
Ron
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 23 2005 - 10:15:57 CST