OraFAQ Forum: Server Utilities => import Problem

Members

Help

Home

Home » RDBMS Server » Server Utilities » import Problem

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

import Problem [message #317944]

Mon, 05 May 2008 01:28

mahesh_sharma217
Messages: 2
Registered: May 2008

Junior Member

I import dmp file with dos command imp. It import all the tables but it did not import packages, procedures and functions. Please tell me what is the problem. I did not assign seperate tablespace.
thanks

Report message to a moderator

Re: import Problem [message #317947 is a reply to message #317944 ]

Mon, 05 May 2008 01:35

Arju
Messages: 1470
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

What is the error?

Report message to a moderator

Re: import Problem [message #317952 is a reply to message #317944 ]

Mon, 05 May 2008 01:45

Michel Cadot
Messages: 15238
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member

Maybe you didn't import or export full database or schema but only a table list.
Post your export and import command lines.

Regards
Michel

Report message to a moderator

Re: import Problem [message #317973 is a reply to message #317944 ]

Mon, 05 May 2008 02:58

mahesh_sharma217
Messages: 2
Registered: May 2008

Junior Member

i have used simple technique for import
in dos i wrote
c:\imp
username = test
passwarrd = test
path = c:\test.dmp
import entire date = yes

This command import all the tables but did no procedures and packages.In dos prompt it show some errors but i did not focus on them.

Please help me what is problem
i am doing work in oracle 10g.
Is there any problem of default tablespace. Or default tablespace size issue.

Report message to a moderator

Re: import Problem [message #317976 is a reply to message #317973 ]

Mon, 05 May 2008 03:04

Littlefoot
Messages: 5640
Registered: June 2005
Location: Croatia, Europe

Senior Member

Quote:

it show some errors but i did not focus on them

Maybe you should have.

Besides, we still don't know WHAT you have exported (to repeat what Michel has already said: perhaps there are no procedures etc. in the export file at all).

Report message to a moderator