This content has been marked as final. Show 2 replies
1 person found this helpful
Sachin B wrote:Yes, and this is expected behaviour when using transportable tablespaces.
I am trying to transport tablespaces from one DB Instance to another db instances on Solaris 64bit, It works fine for Tables/Index and constrains but
unable to transport Functions and Sequences.
It's explained here
how to add sequences , function and procedures in expdb or any other method i can use to export these objects?Use data pump
The only objects that are exported as part of transportable are objects associated with the tablespaces that you list. If you want to see the complete list, you can query the view:
select unique full_path from SYS.datapump_paths where het_type = 'TRANSPORTABLE_EXPORT';
This will give you what gets exported as part of a datapump transportable export job. If you need to export synonyms or packages, you can use datapump, but you will either need to use the schema mode or full mode. You can add the include parameter to only get what you want.
Hope this helps.