Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Importing a user that has views that access functions

Importing a user that has views that access functions

From: Paul <paul.cockburn_at_blueyonder.co.uk>
Date: 21 Aug 2001 09:28:55 -0700
Message-ID: <43f59654.0108210828.5fe32d33@posting.google.com>


I am having trouble importing a user.

The user has a number of views. Some of these views access stored functions (also owned by the user).

When the import utility trys to create the view, it generates a warning. I presume this is because the function that the view accesses has not yet been imported as this comes later in import process.

Is there any way around this. ie. how do you do a "clean" import of a user if there is a dependency between objects that are being imported.

Thanks in advance for any help.

Paul. Received on Tue Aug 21 2001 - 11:28:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US