RE: how to use "imp" to import table and rename it?

From: Taylor, Chris David <Chris.Taylor_at_ingrambarge.com>
Date: Tue, 18 Dec 2007 14:31:03 -0600
Message-ID: <17E4CDE8F84DC44A992E8C00767402E0860DEC@spobmexc02.adprod.directory>

Not that I know of

I always use (where users A&B are actual db usernames) FROMUSER=USERA
TOUSER=USERB In my import parameter file that will cause the table to imported into a different schema than where the table currently exists.

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor_at_ingrambarge.com

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Tuesday, December 18, 2007 2:23 PM To: oracle-l_at_freelists.org
Subject: how to use "imp" to import table and rename it?

Does their has way use "imp" utility import table and rename it under 9ir2 environment?

Thanks.  

---

---

Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 18 2007 - 14:31:03 CST