Link to home
Start Free TrialLog in
Avatar of tomvv
tomvv

asked on

export import

please answer exactly

when we user oracle export utility

we create a directory to export..

now we export the data

using export utility...

I want to import that exported data to different database

can u please help me..

also want help in creating in linux or through oracle for creating directory...
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

>>please answer exactly

What is the exact question?

>>I want to import that exported data to different database

Create the new database.  Other than that, it depends on the export taken and with what options.  You might need to pre-create the tablespaces and/or users.

There are also two versions of export/import.  The classic: exp/imp and the new datapump versions, expdp/impdp.  Since you mentioned directories, I assume datapump.

The docs should have everything you need:
http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_import.htm#i1007653

>>also want help in creating in linux or through oracle for creating directory...

I don't understand this.  Oracle directories are different from Operating System (OS) directories.  Oracle directories are internal objects pointing to OS folders/directories.

Again the docs doe Oracle directories:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_5007.htm#SQLRF01207
>>also want help in creating in linux or through oracle for creating directory...

You can create Oracle directory object pointing to an existing directory on the O/S whether it is Linux or Windows. Alternatively you can first create an O/S directory on linux or windows and then create the Oracle directory object pointing to that O/S directory.

To create directory in Linux:
for example
mkdir /d02/oradir

make sure oracle owns it
chown oracle:oinstall /d02/oradir

To create oracle directory object
SQL>CREATE DIRECTORY mydir AS '/d02/oradir';

Grant permission to it
SQL>GRANT read,write ON DIRECTORY mydir TO user;
replace use with the user you're granting access to.

Hope this helps in a small meanure.
R.
Avatar of tomvv

ASKER

after export it is going to the same server or we can export to different server..

then can we import that object to whichever database we want..

can u provide an example with syntax
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial