Importing oracle dump into Unix DB

Computing.Net > Forums > Unix > Importing oracle dump into Unix DB

Importing oracle dump into Unix DB

Original Message

Name: sajan1
Date: February 9, 2005 at 09:04:51 Pacific
Subject: Importing oracle dump into Unix DB
OS: UNIX
CPU/Ram: 256

Comment:

Hi,
I need to import a Oracle database dump file into a Unix server. Could you please let me know how to do it in a Unix server ?

Report Offensive Message For Removal

Response Number 1

Name: Jim Boothe
Date: February 9, 2005 at 09:28:35 Pacific

Reply: (edit)

Are you importing into an Oracle database? Oracle import utility has the same usage on windows/unix/linux:
imp help=y

Report Offensive Follow Up For Removal

Response Number 2

Name: sajan1
Date: February 9, 2005 at 09:39:50 Pacific

Reply: (edit)

Hi Jim,
Yes, i am trying to import the dump into the oracle database. Though I know how to import the dump into a windows based database , I dont have much idea about Unix .

Report Offensive Follow Up For Removal

Response Number 3

Name: Jim Boothe
Date: February 9, 2005 at 12:40:56 Pacific

Reply: (edit)

Oracle on Windows and Oracle on unix/linux are pretty much the same.
I am assuming that the Oracle database is running. You can see all running Oracle instances with:
ps -ef | grep ora_
Set up your variables for your Oracle Home and database, such as:
ORACLE_HOME=/d01/oracle/9.2.0
ORACLE_SID=DEV
export ORACLE_HOME ORACLE_SID
Add the bin directory to PATH:
PATH=$PATH:$ORACLE_HOME/bin
You should now be ready for your import:
imp scott/tiger file=myfile.dmp ...

Report Offensive Follow Up For Removal


ld:0706-006 cannot find or open lib Oracle 7 Installation on SCO Unix Query on Oracle running on Unix server Telnet into Unix Openserver 5.0.5 getting started with unix?	Accessing Unix Directories in .Net. variables from one file to another Im a newb and want to get into Unix Dial Up Connection to Unix Servers Unix Kernel Programming

Help : running sqlplus in...

Vi Editor help...

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: Importing oracle dump into Unix DB

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

Have you ever used OpenOffice?

Poll Finishes In 6 Days.
Discuss in The Lounge

install Apache server 2.0.63

radeon HD 3850 agp. is my system u

Cant complete booting

Change reg query output

Flashing walls in the Sims

All Posts Awaiting Replies