Total Pageviews

4505

Use Oracle-Linux expdp to windows network drive

Create directory under /u01/ in Linux using mkdir

cd /u01

mkdir dumps


then mount it using mount


mount -t cifs -o username,password //servername/sharename /u01/dumps/


where username and password is Windows-user able to access the share and //servername/sharename is the path of my share (servername = IP address if not able to resolve DNS)

How to Mount Windows Share on Linux using CIFS?

On Linux and UNIX operating systems, a Windows share can be mounted on a particular mount point in the local directory tree using the cifs option of the mount command.

The Common Internet File System (CIFS) is a network file-sharing protocol. CIFS is a form of SMB.

Red Hat Enterprise Linux Server release 5.11

Samba RPM required

samba-3.0.33-3.41.el5_11
samba-client-3.0.33-3.41.el5_11
system-config-samba-1.2.41-5.el5
samba-common-3.0.33-3.41.el5_11


Then create directory on Oracle DB

mount-t cifs "//server/share$" /mnt/test -o user=myuser,password=mypasswd,dom=mydomain -o uid=user,gid=group,file_mode=0775,dir_mode=0775

CREATE OR REPLACE DIRECTORY DUMP_DIR AS '/u01/dumps'

expdp AAA/***@xxx schemas=AAA include=TABLE:\"= \'TBL001\'\" directory=DUMP_DIR dumpfile=dmpfile.dmp logfile=lgfile.txt

No comments:

Post a Comment

ORA-00845: MEMORY_TARGET not supported on this system

 The shared memory file system should have enough space to accommodate the MEMORY_TARGET and MEMORY_MAX_TARGET values. To verify: SQL> sh...