| 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?
What about performing a tables= import of the schema export? This should bring the tables, indexes, data, table triggers, and constraints. It would skip the stored procedures, functions, and packages as well as views. Views are easy to grab from the rdbms dictionary, if any. Private synonyms as well as public ones to the user objects would need to be recreated but again this is easy using the dictionary.
-----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.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.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 17 2007 - 16:00:35 CDT
 |
 |