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

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <mccdba1@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 17 Apr 2007 15:35:15 -0400

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc
Sent: Tuesday, April 17, 2007 2:45 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l


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


Other related posts: