Oracle materialized view log structure
To refresh a materialized view quickly, you must create a materialized view log. This article briefly describes the meaning and usage of each field in the materialized view log.
The name of the materialized
ORA-12034: The materialized view log on SCOTT. "USER_TABLE" is newer than the last refresh
Recently, when I handed over my work, I found that several schedule jobs were not successfully executed. I have shown that one of them is due to database
In 11.2, materialized view logs also add features that, for local materialized views, can now be refreshed using the commit SCN instead of the timestamp method in the previous version.
Look at a simple example:
Sql> SELECT * from V$version;
Recently colleagues in the handover work, found that there are several schedule job did not succeed, I looked at the next, one is due to the database migration, call Dblink host IP in TNSNames no change caused, there is no view of the error, that is,
016-09-27 14:36:09,802 ERROR [500.jsp]-Could not commit JDBC transaction; Nested exception is java.sql.sqlexception:ora-12048: Refreshes the materialized view "the". Check_form "Error
ORA-12034: "Teenagers". The materialized view log on Ch_task is
log files are files used to record various running messages in a Linux system, and different log files record different types of information, which can be helpful in diagnosing and resolving problems in the system. Parsing log filesThere are three
View Log files in Linux 1. create the working directory mkdir-p/usr/local/viruswww.2cto. com2. download the Log analysis script cd/usr/local/logs written by laruence.
View Log files in Linux 1. create the working directory mkdir-p/usr/local/virus
Common view Log commands in the CentOS systemTime:2014-03-10 23:52Source:Blog.csdn.netAuthor:NothingLinux IDE RedHat firewall activity.CatTail-fLog file description/var/log/message system startup information and error log, which is one of the most
1. View Log common commands tail:- n is the display line number, equivalent to the NL command;tail-100f Test.log Real-time monitoring of 100 rows of logsTail-n test.log query log at the end of the last 10 lines;Tail-n +10 test.log Query all logs
Linux View log file Contents command tail, Cat, TAC, head, EchoTail-f Test.logYou will see that the screen is constantly being printed out. This time interrupts the first process ctrl-c,---------------------------How Linux displays a few lines of a
1. View Log common commands tail:-n is the display line number, equivalent to the NL command; examples are as follows:tail-100f Test.log Real-time monitoring of 100 rows of logsTail-n test.log query log at the end of the last 10 lines;Tail-n +10
1. To view log log, modify the configuration file My.ini and modify it under [mysqld]:2. After the modification, restart the MySQL service to take effect;3. The Error_log,slow_log log timestamp defaults to UTC after the default installation,
Linux View log file Contents command tail, Cat, TAC, head, EchoTail-f Test.logYou will see that the screen is constantly being printed out. This time interrupts the first process ctrl-c,---------------------------How Linux displays a few lines of a
Log file storage logs are very large, we can not use VI directly into the log, we need the Linux command to complete our viewing tasksLog location:/var/log/message information and error log after system startup is one of the most frequently used
MySQL enable log, view LogMYSQLEnable logging[Email protected]]# whereis My.ini[[Email protected]]# vi/etc/my.cnf[MySQLDdatadir=/var/lib/MySQLsocket=/var/lib/MySQL/MySQL. SockUser=MySQL# Default to using old password format for compatibility
Linux View log file Contents command tail, Cat, TAC, head, EchoTail-f Test.logYou will see that the screen is constantly being printed out. This time interrupts the first process ctrl-c,---------------------------How Linux displays a few lines of a
(Switch) add, delete, modify, query, and view log records in MySql, and mysql log records
Reprint address: http://blog.51cto.com/hades02/1641652
First, enter show global variables like '% general %' in the command line, and then the following
Nginx view log, nginx log
Nginx logs include access logs and error logs.
The access log records the users, pages, user browsers, ip addresses, and other access information.
The error log is used to record server error logs.
The error log format is
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.