Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How can we use commit inside a triggers ?

blessed DBAMar 7 2018 — edited Mar 8 2018

How can we use commit inside a triggers ?

Comments

807557
If you have access to both Storeg Systems from the hosts, or access from host to host, you can try something like (assuming autofs is running):

1. Login into new server 
# (cd /net/old-server/your-directory;find .)|cpio -pdv /new-directory
OR 
# cd /destination-directory
# (cd /net/old-server/source-directory; tar cEf - .)|tar xvf -
If you do not have autofs running and do not want to have it running or any other problem with autofs, you can use SSH to transfer files using tar
http://www.cyberciti.biz/faq/howto-use-tar-command-through-network-over-ssh-session/

If You still have problems with SSH, you can also use tar on top of telnet

Cheers
Andy
807557
Quoting cpio man page:

281 ... " .....................................To transfer a large file
282 ... (8 Gb - 1 byte), the header format can be
283 ... tar|TAR, ustar|USTAR, or odc only."

"header format" configured with -H option.
SEE ALSO ...largefile(5).


737 ... " The new pax(1) format, with a command that supports it (for
738 ... example, pax , tar, or cpio), should be used for large
739 ... files. The cpio command is no longer part of the current
740 ... POSIX standard and is deprecated in favor of pax. "
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 5 2018
Added on Mar 7 2018
#general-database-discussions
5 comments
133 views