OraFAQ Forum: Server Utilities » Import Views and Functions from dump file

Home » RDBMS Server » Server Utilities » Import Views and Functions from dump file (Solaris 9; Oracle 9i;)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import Views and Functions from dump file [message #404441]

Thu, 21 May 2009 19:22

Erdenejargal
Messages: 18
Registered: July 2008

Junior Member

Hi guys,

I have problem with import views and functions.

I got the backup using exp tool. There is no error.

# exp parfile=full.par

full.par files content:
userid=system
Full=y

And I want to import only views and functions from dump file.
Also if it exists in the database, overwrite it.

But I do not know how.
I searched but did not find the solution in the Oracle 9i.

BR,
Erdenejargal.B

Report message to a moderator

Re: Import Views and Functions from dump file [message #404443 is a reply to message #404441]

Thu, 21 May 2009 19:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I have problem with import views and functions.
import does not support that level of granularity.

Report message to a moderator

Re: Import Views and Functions from dump file [message #404446 is a reply to message #404441]

Thu, 21 May 2009 19:34

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You will have to extract it from dumpfile.
use show=y and logfile=somelogfile.sql during import.
somelogfile.sql will have all the ddl.

If the source database is accessible, it is easier to get the DDL from source.

Report message to a moderator

Re: Import Views and Functions from dump file [message #404448 is a reply to message #404446]

Thu, 21 May 2009 19:40

Erdenejargal
Messages: 18
Registered: July 2008

Junior Member

I'm new in Oracle. Razz

How to extract the dump file?

BR,
Erdenejargal.B

Report message to a moderator

Re: Import Views and Functions from dump file [message #404450 is a reply to message #404448]

Thu, 21 May 2009 19:56

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

quoting myself.
>>use show=y and logfile=somelogfile.sql during import.

Report message to a moderator

Re: Import Views and Functions from dump file [message #404452 is a reply to message #404441]

Thu, 21 May 2009 20:02

Erdenejargal
Messages: 18
Registered: July 2008

Junior Member

If I finished the import process (Full=y ingore=y), is it import every thing with error messages?

BR,
Erdenejargal.B

Report message to a moderator

Re: Import Views and Functions from dump file [message #404487 is a reply to message #404441]

Fri, 22 May 2009 00:07

Erdenejargal
Messages: 18
Registered: July 2008

Junior Member

Thank you for reply.

I've got the solution.
When I import the data using with fromuser,touser options, it works normal. It can import the view and functions.

BR,
Erdenejargal.B

Report message to a moderator

Previous Topic:	stored procedure for creating a new schema from an old one
Next Topic:	sqlloader continueif problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 14 22:14:45 CST 2025