About the function of time:
Strftime formatting local time/date based on regional settings
strptime-parsing date/time generated by strftime ()
setlocale function Setting Region information (Geographic information)
Date_default_timezone_set if
Php learning about time. Time Functions: strftime format the local time/date according to the region settings strptime parse the date/time setlocale function generated by strftime () to set the region information (local domain information about the
Premise:-Standby database must is in Flashback database mode. -time at which Drop/truncate/delete Table happened should is within the db_flashback_retention_target and all the Flashba CK and archive logs should be availableRetrieve the wrong
Oracle Update Data Tip Custom "ORA-20010: Cannot drop/truncate the table" errorJava.sql.batchupdateexception:ora-00604:error occurred at recursive SQL Level 2ORA-20010: The table cannot be drop/truncate.Ora-06512:at Line
Time Functions: strftime format local time/date strptime & mdash according to region settings; parse the date/time setlocale function generated by strftime () to set region information (Region information) date_default_timezone_set if the result of
1. Description of the flashback Table FunctionRestore the data table to a previous time point or SCN number.Note: This function changes the current table and its affiliated objects to a previous state.
2. system parameters to be
Gets the timestamp of the current system time#pragma mark-Gets the timestamp of the current time+ (Nsinteger) getnowtimestamp{NSDateFormatter *formatter = [[NSDateFormatter alloc] init];[Formatter Setdatestyle:nsdateformattermediumstyle];[Formatter
1 method of Rollback after Oracle submits data with Pl/sql
1, if the database table, does not support the flash-back functionALTER TABLE A enable row movement;2, query Delete data point of time data (that is, flash back to the point before the
Turn on the flash back databaseALTER DATABASE flashback on;ALTER DATABASE open;Modify Date Time display format:Alter session set nls_date_format= ' Yyyy-mm-dd hh24:mi:ss ';View the Flashback database log information in the system view
There are two methods: SCN and time stamp two methods of recovery.I. Recovering deleted and committed data through the SCN1. Obtain the SCN number of the current databaseSelect Current_scn from V$database; (Switch to SYS user or System user
/*The flashbackup of 11g is divided into several kinds, which are different in use.A.flashback database Flashback, the simple idea is to flash the database back to a previous point in time,The earliest SCN that can be recovered depends on the
1 , the definition of time stampTimestamp refers to the creation, modification, and access time of the file attributes. Digital Timestamp technology is a variant application of digital signature technology. In e-Commerce transaction files, time is
Use of Oracle Flashback table
Oracle ensures that recyclebin is enabled
SQL> show parameter recyclebin
NAME TYPE VALUE-----------------------------------------------------------------------------Recyclebin string ON creates a table
SQL> create table
Retrieve the Table that has been mistakenly dropped/Truncate/Delete on the primary database on the standby Database
Prerequisites:
- Standby Database Must be in Flashback database mode. - Time at which Drop/Truncate/Delete Table happened should be
IOS timestamp string NSdate conversion demo
1. In projects, we often need to convert the time format. The following is my encapsulated NSDate + TimeCategory, hoping to help you.
# Import
@ Interface NSDate (TimeCategory)/*** convert string
Conversion of time and time stamps in iOSGets the timestamp of the current system time#pragma mark-Gets the timestamp of the current time+ (Nsinteger) getnowtimestamp{NSDateFormatter *formatter = [[NSDateFormatter alloc] init];[Formatter
Make sure RecycleBin is open.
Sql> Show Parameter RecycleBin
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
RecycleBin string on
Create a table
Sql> CREATE TABLE TAB01 (id int);
Table created.
Configure Flashbash Database Parameters
ALTER system SET db_recovery_file_dest= '/dg/fra ';ALTER system SET db_recovery_file_dest_size=10g;ALTER system SET db_flashback_retention_target=1440;ALTER DATABASE flashback on;
Primary library to build
Oracle Flashback is a fast and easy database recovery technology, it does not use backup files, through the flashback log can restore the database to a state of the past, when the user logic error (delete table data, table, table space, etc.) need
Flashback Flashback query (undo) SELECT * FROM table_name as of timestamp To_timestamp (' 2008-03-03 12:00:00 ', ' yyyy-mm-dd hh24:mi:ss '); SELECT * FROM table_name as of SCN 123456; Flashback table (undo, Restore table to a point in time, block
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.