Home » RDBMS Server » Server Utilities » import Problem
import Problem [message #317944] Mon, 05 May 2008 01:28 Go to next message
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
Re: import Problem [message #317947 is a reply to message #317944] Mon, 05 May 2008 01:35 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

What is the error?
Re: import Problem [message #317952 is a reply to message #317944] Mon, 05 May 2008 01:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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
Re: import Problem [message #317973 is a reply to message #317944] Mon, 05 May 2008 02:58 Go to previous messageGo to next message
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.
Re: import Problem [message #317976 is a reply to message #317973] Mon, 05 May 2008 03:04 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
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).
Re: import Problem [message #318003 is a reply to message #317973] Mon, 05 May 2008 04:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
passwarrd = test

passwarrd is not a valid parameter.
Better than saying what you did, copy and paste it.

Regards
Michel

[Updated on: Mon, 05 May 2008 04:55]

Report message to a moderator

Re: import Problem [message #318112 is a reply to message #317973] Mon, 05 May 2008 13:11 Go to previous message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
mahesh_sharma217 wrote on Mon, 05 May 2008 03:58
i have used simple technique for import
in dos i wrote
.
.
.
import entire date = yes



What does this mean?
Previous Topic: sql * loader
Next Topic: shadow copy
Goto Forum:
  


Current Time: Thu Dec 08 06:33:23 CST 2016

Total time taken to generate the page: 0.19291 seconds