Question:When archiving a data table, you must check whether the data can be saved. If not, a dialog box is displayed, asking the user to choose whether to archive the data.Problem Analysis:
1) in the archive script, add a dialog box to judge and execute the corresponding action based on the user's choice.
PS: in this way, you need to modify the archive script file of Oracle PLSQL. I have not found the relevant information to implement the Add dialog
limit on this path, that is, it only has 2 GB space by default. It is not only the default path for archiving logs, but also the default address for backup files and flash back logs, in this way, the space used by the archive log lock cannot reach 2 GB. If the path size is not set, many systems have encountered problems where the archiving logs are full and cannot be archived.If there is not enough space,
/flash_recovery_area ). Oracle has a limit on this path, that is, it only has 2 GB space by default. It is not only the default path for archiving logs, but also the default address for backup files and flash back logs, in this way, the space used by the archive log lock cannot reach 2 GB. If the path size is not set, many systems have encountered problems where the archiving logs are full and cannot be arc
Jar-Java archiving Tool
Merge multiple files into a single JAR file.
Structure
jar [ options ] [manifest] destination input-file [input-files]
Description
The jar tool is a Java application that combines multiple files into a single jar archive file.JarIs a versatile archive and compression Tool Based on Zip and zlib compression formats. However, designJarJava applet or application package into a single archive file. Add the applet or applicat
################################################Tar: Archive-only uncompressed-C: Create an archive file-F Filename.tar: Archived files for operations-X: Expand Archive file--xatrrs: Preserve extended properties of files when archiving-T: View archived content, do not expand-ZXF: Archive and invoke gzip compressionTAR-ZXF txt.tar.gz-ZXF: Call gzip to unzip and expand archive-JXF: Archive and call bzip2 compressionTAR-JXF txt.tar.bz2-JXF: Call bzip2 to
to archive filesTAR-XF Filename.tar do not expand the archive and directly view which files are archived-C: Create an archive file-F File.tar Generated archive file-X Expand Archive file--xattrs: Preserves extended attribute information for files when archiving-T: Do not expand the archive to directly see which files are archivedTar can call each of the compression command implementations to both archive and compress.-ZCF: Archive and invoke gzip co
the original file when compressingUNXZ: Unzip unxz somefiles.xz: Delete the original compressed file after decompression is completeXzcat somefiles.xz: View text file contents in XZ compressed fileZip : A tool that is both archived and compressed zip filename.zip somefiles: Do not delete the original file after compression Unzip Filename.zip: Unzip- C : Specify the target path after decompressionTar : Archive Tool- C: Create an archive file-F File.tar: Archived files for Operations- x: Expand A
Compress bz2, XZ, zip, ZThe directory cannot be compressed and the original file is deleted by default after compression.Gz:gzip/path/filename-D DecompressionGunzip/paht/some_filenameZcat/path/somefile.gz: View the contents of the text file under the condition of no pressure.BZIP2: There is a greater compression ratio than gzip.Bzip2/path/some_filename-D Decompression-K Keep the original fileBunzip2/path/some_filenamebzcat/path/somefile.bz2Xz:xz/path/some_filename-D Decompression-K Keep the orig
of a text file compressed by Xzcat in the case of decompression.Xzdec:
Role
Unzip.Zip:
Role
Compress multiple files. Do not delete source files after compressionZip Filename.zip FILELISTUnzip
Role
Unzip compressed files by Zip.Tar
Role
Archive file. Archive only, do not compress, do not delete source files.
Options
-C: Create an archive file.-F: The archive file for the operation.-X: Restores the archive.--xattrs: Retains its
*.xz use: Xzcat-------------------------------------------------Since the directory cannot be compressed directly, we need to archive the directory (archive) into a single file before compressingLinux Common Archive Command: Tartar command :Common Parameters-C: Create an archive-X: Expand Archive-F FileName: Specifies the file name after the archive, typically with *.tar as the filename-T: Do not expand the archive to view the list of archived files-C: Specifies the path after the archive is exp
> Coverage>> AppendArchive (archiving) is the packaging of many files (or directories) into one fileCommon options for the tar command:C: Create a new tar file.T: Lists the contents of the directory in the tar file.X: Extract the files from the tar file.F: Specify the archive or tape (or possibly floppy) device (typically selected).V: Displays the details of the packaged file, and V is the 1th letter of the verbose.Z: Use the gzip compression algorith
Anyone who has ever used SharePoint knows that SharePoint for the operation is convenient, but for the data load is not satisfactory, so that we need to more reasonable use, standardize the use of rules and habits, so, regular cleaning unnecessary documents has become a problem.
With this in mind, I think it's convenient to write a gadget that implements document archiving. Of course, if you want, it can be encapsulated as Timerjob or Windows service
or with the pipe command {Related Commands Tar[Gunzip]Gunzip Unzip the *.gz and delete the original fileRelated Commands gzip[Gzip]Gzip Compress a file into GZ format and delete the original file.Related Commands Gunzip-D -[1,9] > [Mkisofs]MKISOFS CD ISO image generation-O -R supports file data with Rock Ridge to record more information-V Textual Representation process-M -V New VolumeUse the Cdrecord command for the engraved disc[Tar]Tar Files or directories are archived and not compressed.-CCr
Tar: create an archive file [Syntax] tar [option] tarfilefilename [command description] the file name must be followed by the-f parameter and
Tar
[Syntax] tar [option] tarfile filename
[Command description]
The file name must be followed by the-f parameter and used as the last parameter;
[Parameter description]
-C. create a new archive file;
-F specifies the file name;
-R: append an object to an archive object;
-X extract files from archive files;
-V and-vv display progress information;
-T list
Linux basic operations-file sorting, splitting, merging, archiving, and other 1sort1sort commands regard the input file as a data stream composed of multiple records, and the record is composed of fields of variable width, the basic format of the 2sort command is sort option Linux basic operation-file sorting, splitting, merging, archiving, etc. The 1 sort 1 sort command regards the input file as composed o
I haven't sent any text for a long time. Send one!
See the official documentation: http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp? Topic=%2Fcom.ibm.db2.luw.admin.ha.doc%2Fdoc%2Fc0024701.html
Use the user exit program to automatically archive and retrieve log files
By creating DB2? The database manager calls the user exit program to perform archiving or retrieval operations, and can automatically perform log file
; startup mount;4. Change the database to archive mode:SQL> alter database archivelog;5. Open the database and query:SQL> alter database open;Modify the log file name format:SQL> alter system set log_archive_max_processes = 5;SQL> alter system set log_archive_format = "archive _ % t _ % s _ % r. log" scope = spfile;After modification, you can check whether the log mode has been modified successfully!In particular, you must modify the log_archive_start = true parameter in Oracle 9i to take effect
To enable and disable oracle archive, if the OPSRAC environment is used, You Need To comment out parallel_servertrue first, then perform the following steps, and use this parameter to restart 1. Enable archive. disable shutdownimmediateb. startupmountc. alterdatabasearchivelogd. alterdatabaseopne
How to enable/disable oracle Archiving
In the OPS/RAC environment, You Need To comment out parallel_server = true first, then perform the following steps
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.