Home » RDBMS Server » Server Utilities » Import Views and Functions from dump file (Solaris 9; Oracle 9i;)
icon2.gif  Import Views and Functions from dump file [message #404441] Thu, 21 May 2009 19:22 Go to next message
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
Re: Import Views and Functions from dump file [message #404443 is a reply to message #404441] Thu, 21 May 2009 19:27 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>I have problem with import views and functions.
import does not support that level of granularity.
Re: Import Views and Functions from dump file [message #404446 is a reply to message #404441] Thu, 21 May 2009 19:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Import Views and Functions from dump file [message #404448 is a reply to message #404446] Thu, 21 May 2009 19:40 Go to previous messageGo to next message
Erdenejargal
Messages: 18
Registered: July 2008
Junior Member
I'm new in Oracle. Razz

How to extract the dump file?

BR,
Erdenejargal.B
Re: Import Views and Functions from dump file [message #404450 is a reply to message #404448] Thu, 21 May 2009 19:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
quoting myself.
>>use show=y and logfile=somelogfile.sql during import.
Re: Import Views and Functions from dump file [message #404452 is a reply to message #404441] Thu, 21 May 2009 20:02 Go to previous messageGo to next message
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
Re: Import Views and Functions from dump file [message #404487 is a reply to message #404441] Fri, 22 May 2009 00:07 Go to previous message
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
Previous Topic: stored procedure for creating a new schema from an old one
Next Topic: sqlloader continueif problem
Goto Forum:
  


Current Time: Sat Dec 10 02:59:27 CST 2016

Total time taken to generate the page: 0.05670 seconds