Hi!
We have an Oracle db export that was compressed and written to DLT tape directly!- This is from box1
The next step is to restore the contents of the tape into the database on box2. The problem is that there is no DLT tape drive attached to box2. There is a box3 that has the tape drive... (1 Reply)
i would like to export a particular table in my oracle database installed in a hpux box. i would like to determine the filesize of the output before performing these action so i can assess if my harddisk can still handle it.
thanks as usuall :rolleyes: (1 Reply)
Hi,
How do i export selected Oracle database schemas from HpUnix?
Is it possible to export it to a windows shared drive?
If so how do i do it?
Pls advice.
Thanks in advance. (4 Replies)
Hi,
Always when I login to Unix, I need to give the following command to view the data properly;
export MAESTRO_OUTPUT_STYLE=LONG
The reason is that by default the settings export MAESTRO_OUTPUT_STYLE=SHORT
Please let me know how I could make LONG as the default and avoid giving the... (1 Reply)
Hi,
I want to write a shell script which will export data from oracle table .
I don't want to save that data . I want the queries .
Right now i am right clicking on the table and clicking on export as to my desktop .
Please let me know if any one have any idea . (2 Replies)
I intend to do parallel export of my Oracle db (i.e all the schema in my db).
Currently I'm using the below exp command in my script:
exp $uid/$pwd@$ORACLE_SID FILE=./DUMP/$today$username.dmp STATISTICS=NONE LOG=./LOG/$today$username.log
For parallel export what should I use?
Please... (1 Reply)
In my Oracle db there are 4 schemas. All the username & passwords are stored in a text file. I am using a while loop to export all the schemas. It read the first line and doing the export. For all users it export one by one.
But I need all the schemas will exported simultaneously. i.e. all the... (1 Reply)
Hi Guys,
I Just wanted your opinion/ suggestion/ Help on my unix script about db2 export data with deli file and import into oracle.
db2 connect to Tablename user id using psswrd
db2 "EXPORT TO '/cardpro/brac/v5/dev/dat/AAAAA.DEL' OF DEL select * FROM AAAAA"
db2 "EXPORT TO... (3 Replies)
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
is this enough to make the data perfect export into delimited file? there are some posted that i read, they... (9 Replies)
Discussion started by: Sonny_103024
9 Replies
LEARN ABOUT OPENSOLARIS
unshare_nfs
unshare_nfs(1M) System Administration Commands unshare_nfs(1M)NAME
unshare_nfs - make local NFS file systems unavailable for mounting by remote systems
SYNOPSIS
unshare [-F nfs] pathname
DESCRIPTION
The unshare command makes local file systems unavailable for mounting by remote systems. The shared file system must correspond to a line
with NFS as the FSType in the file /etc/dfs/sharetab.
OPTIONS
The following options are supported:
-F This option may be omitted if NFS is the first file system type listed in the file /etc/dfs/fstypes.
FILES
/etc/dfs/fstypes
/etc/dfs/sharetab
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWnfssu |
+-----------------------------+-----------------------------+
SEE ALSO nfsd(1M), share(1M), attributes(5)NOTES
If the file system being unshared is a symbolic link to a valid pathname, the canonical path (the path which the symbolic link follows)
will be unshared.
For example, if /export/foo is a symbolic link to /export/bar (/export/foo -> /export/bar), the following unshare command will result in
/export/bar as the unshared pathname (and not /export/foo):
example# unshare -F nfs /export/foo
For file systems that are accessed by NFS Version 4 clients, once the unshare is complete, all NFS Version 4 state (open files and file
locks) are released and unrecoverable by the clients. If the intent is to share the file system after some administrative action, the NFS
daemon (nfsd) should first be stopped and then the file system unshared. After the administrative action is complete, the file system would
then be shared and the NFS daemon restarted. See nfsd(1M)SunOS 5.11 6 May 2003 unshare_nfs(1M)