Re: [Q] import schema but not with procedures/functions?

I'd like to question your assertion "import tables are not feasible". You can easily generate a parameter file by spooling under SQL*Plus the result of a query against USER_TABLES. Better, you can even generate SEVERAL such files, and run everything in parallel (and you can order by table size in terms of block used, and try to balance the total size of each "thread"). I guess you won't have any problem generating CREATE INDEX statements; the only thing you really have to be careful with are constraints, but even so ...

Alternatively, I presume that revoking the CREATE PROCEDURE privilege before importing as the user might help ... But you will have to export them if you do a schema export.

HTH Stéphane Faroult

dba1 mcc wrote:
> 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