Solved

Imp & exp in databse in unix

Posted on 2003-11-21
6
1,883 Views
Last Modified: 2010-08-05
hi
i m having oracle 8i version on unix platform.
now i want to export & imp database .

I am aware imp & exp command on dos promt.
But don't know in unix.

Pls tell me asap.

Thank u
sameer
0
Comment
Question by:sameerasawant
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 50 total points
ID: 9797535
Logon as oracle user. In many cases it is the user "oracle"
This user has to have in his PATH envirinment variable path to $Oracle_home\bin directory where Import (imp) and Export (exp) utilities resides.

Run it so:
% exp
% imp

where % is the Unix prompt.
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 9797623
In a nutshell, they are used in the same way as in Windows.
0
 

Expert Comment

by:indy1
ID: 9799955
Hi,

I have a value 1238.50 in a field say SALARY in a table say EMP. Now I want two things:

1)  I want to search the tables which are also having this same field SALARY.
2)  I want tables which are having value 1238.50, no matter fielad name is same or not.

Thanks in anticipation.
0
 
LVL 8

Expert Comment

by:baonguyen1
ID: 9809585
Need help on exp/imp, from Unix prompt:

-Log on as oracle user
-Issue:

$exp help=y
or
$imp help=y
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question