473,382 Members | 1,717 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

How to import a dump file into Oracle on linux?

I have a dump file and want to import in Oracle ... ubuntu,
I use the Command
$./imp user/passwd file="nani.dmp" FROMUSER=system TOUSER=jagan

and i got the output. The files are imported.

But the problem is.....
the files are come from system User not from the given dump file. What is the Problem?
Sep 30 '10 #1
1 6547
rski
700 Expert 512MB
What does it
But the problem is.....
the files are come from system User not from the given dump file. What is the Problem?
mean?
Sep 30 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: Jamie Meyers | last post by:
Does anyone know how to import a .sql dump file into a mysql database using php. I know how to do it using commandline, mysql < test.sql, but I am writing an install script, and was wondering if...
6
by: Daniel Gwynne | last post by:
I am trying to read a mysql dump file that I was given from a mysql dump file into my mysql server, I am using the following command at the mysql command line and get the following error: mysql>...
1
by: steve | last post by:
Hi, I have a 80 meg dump file created with mysqldump. I need to import it into a mysql db on Windows. On linux, I say "shell>mysql dbname < dumpfilename" But that does not work on Windows. ...
4
by: news | last post by:
Our production database in an exported textfil runs about 60 MB. Compressed that's about 9 MB. I'm trying to import the export into another machine running FC3 and mySQL 11.18, and it appears as...
9
by: Shivam | last post by:
Hi All, I have a mysql dump file... something like. __________________________________________________ CREATE TABLE nation ( ip int(11) unsigned NOT NULL default '0', country char(2) NOT...
1
by: umeshkul | last post by:
Hi, I am new in DB2. In DB2 dump file of export option is OS dependent. I want to export a data from windows machine to linux machine using export/import option. Can anyone help me please? ...
3
by: Nurullah | last post by:
hi how can i import .dmp file into oracle 9i.give me details.i'm new in oracle so i need to no where i write solution comand.i find answer but i didn't know how it works
1
by: TYR | last post by:
I have a large dump file that originated in a MySQL db; I need to get it into an SQLite file. Various options are suggested around the web; none of them seem to work (most failing to import the...
1
by: davidson1 | last post by:
Hai friends, In our college we have oracle database , i need the old records for testing my project , and the old records are in dump file. Now i need to tranfer the data from oracle dump file...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.