Search code examples
oracledatabase-migration

Using Oracle exp imp tool


I use Oracle 11 on my local server, and wanna export my data using oracle exp tool:

http://docs.oracle.com/cd/B28359_01/server.111/b28319/exp_imp.htm#i1023725

I dont have any views, triggers or stored procedures, just ordinary tables and some image blobs in one table. It should be really simple to export this.

But I really didn't understand anything how to do it;

  • First of all, It says I should run the catexp.sql or catalog.sql before I run the exp tool..Ok but where the heck is these scripts? I searched my computer bu no such thing exists.

  • Second it is still not clear what needs to be done, What .exe exactly I need to run. And then it says;

    exp PARAMETER=value
    

What the heck is parameter what the heck is value?..Is there any better documentaion or anyone can explain with simple terms the steps I need to take?


Solution

  • You only need to run catexp/catalog if they haven't been run already for some reason; they would normally exist and be run as pat of the database creation, so you probably don't need to worry about those.

    PARAMETER is a placeholder for any of the supported parameters, as shown under 'invoking export and import'.

    You need to specify an export (dump) file; the default is create a file called EXPDAT.DMP in the current directory. If you don't have permissions to write to that directory you need to specify the full path to where you want the file to be created, including its name.

    There are [several export examples], including table mode and user mode. When you run interactively and don't specify OWNER or TABLES on the command line or in a parameter file you're prompted to choose the mode, which is the 'users or tables' prompt you saw. You might want something like this example:

    exp blake/paper FILE=blake.dmp TABLES=(dept, manager) ROWS=y COMPRESS=y
    

    ... but with your own user/password, file name (and path), and table names.