RE: [Q] import schema but not with procedures/functions?

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 17 Apr 2007 15:35:15 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF270BF5DB0E@AABO-EXCHANGE02.bos.il.pqe>

Hmm...in 10g /w datapump, it's easy....I don't see any obvious solution for 9i, though....

Perhaps I'm overlooking something...?

-Mark

--

Mark J. Bobak
Senior Oracle Architect
ProQuest/CSA

"There are 10 types of people in the world: Those who understand binary, and those who don't."

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Tuesday, April 17, 2007 2:45 PM
To: oracle-l_at_freelists.org
Subject: [Q] import schema but not with procedures/functions?

We have ORACLE version 9.2.0.8 on LINUX server. I tried to export and import a user (schema) to another database.

Does there has way just import schema's data, but not import procedures, functions and packages?

NOTE: this schema have hundreds tables, import tables are NOT feasible.

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 17 2007 - 14:35:15 CDT