| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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.
FAX: 734-930-7611 E-Mail: jim.silverman_at_thomson.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark
Sent: Tuesday, April 17, 2007 3:35 PM
To: mccdba1_at_yahoo.com; oracle-l_at_freelists.org
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_at_freelists.orgReceived on Tue Apr 17 2007 - 14:55:45 CDT
[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. -- http://www.freelists.org/webpage/oracle-l
 |
 |