Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Importing Functions and Packages
The only way to get functions and packages is to do a schema level (or full) export. If you specify rows=n in your export, you'll still get the table/index DDL, create view statements, etc., but no data. This is fine assuming you're going into a schema with duplicate tables, etc. In that case, you can import the file with ignore=y. This will get you pass all the DDL creation errors, and still load in the code. If the schema does not contain all of the DDL objects in the export file, those objects will be created. Hope this helps.
Byron Lee
stuarti <stuirvineNOstSPAM_at_hotmail.com.invalid> wrote in message
news:11c2980f.7fc64b44_at_usw-ex0104-033.remarq.com...
> Does anybody know to import just the functions and packages into
> a users schema from an export file. (full export)
>
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Tue May 23 2000 - 00:00:00 CDT