Database Utilities (MOSC)

MOSC Banner

export / import a schema

edited Feb 14, 2013 9:28AM in Database Utilities (MOSC) 5 commentsAnswered
Hello everybody,

I plan to move my database from windows 32 to ODA architecture (linux 64)

I've exported the owner schema and I blocked on importing it on Linux.

The export is the file exp.dmp

//172.20.2.6/temp is my windows computer where the export was created.

[oracle@odaprod1 smb]$ df -h|grep temp
//172.20.2.6/temp     272G  155G  118G  57% /mnt/smb

[oracle@odaprod1 smb]$ ls -al
total 129959456
drwxr-xr-x 1 root root            0 Feb 14 14:28 .
drwxr-xr-x 3 root root         4096 Feb 12 17:40 ..
-rwxr-xr-x 1 root root           11 Feb 12 17:56 111.txt
-rwxr-xr-x 1 root root            0 Feb 14 13:22 abc.txt
-rwxr-xr-x 1 root root            9 Feb 12 17:51 adi.txt
-rwxr-xr-x 1 root root 133078470656 Feb 13 16:59 EXP.DMP
-rwxr-xr-x 1 root root          584 Feb 14 12:56 imp.log

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center