export/import objects to different schemas 
Author Message
 export/import objects to different schemas
Hello,

I'm hoping this is a fairly simple question...

Is there a way to import non-table objects such as procedures, packages,
etc. into a different schema than where they've been exported from?  I
realize there's the FROMUSER, TOUSER, and TABLES keywords for import.
However, I only want to specify certain objects to be imported.  Is there
such a thing as an OBJECTS or PROCEDURES keyword for import?  Or should I be
doing this a different way -- such as recompiling them on the new DB?

TIA,
Verna



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. RFD: schemas and different kinds of Postgres objects

2. RFD: schemas and different kinds of Postgres objects

3. Help - tkprof output different for 2 schemas with same objects

4. export/import schemas/roles

5. EXPORT/IMPORT - Restoring Users' Schemas

6. export/import different SID

7. export, import on different NLS_LANG servers

8. Export - Import: Different User with trigger problems

9. import/export between different databases

10. Export/import from different character sets

11. export/import between different op.system platforms

12. Export/Import Different Columns


 
Powered by phpBB® Forum Software