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

Well, this is kinda kludgy, and I'm not really sure I fully understand
what you're trying to accomplish, but you might try revoking CREATE
PROCEDURE from the user into whose schema you're importing this file.
The statements in the dump file to create these objects will obviously
fail, generating corresponding errors in the log file, but this
shouldn't hurt anything.  You can then re-grant this privilege to the
use once the import has finished.

=====================================
Jim Silverman
Senior Systems Database Administrator
Solucient, LLC - A Thomson Company
Telephone:   734-669-7641
FAX:            734-930-7611
E-Mail:         jim.silverman@xxxxxxxxxxx


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark
Sent: Tuesday, April 17, 2007 3:35 PM
To: mccdba1@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: [Q] import schema but not with procedures/functions?

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.

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


Other related posts: