Database Administrator

1. Save the excel file as. csv. 2. Use Notepad to open the. csv file. The first line is all fields. 3. Create a table structure Create table yu_rt_01 asselect Transaction_Id, Last_Update_Date, Last_Updated_By, Creation_Date, Created_By,

I. First of all, I am talking about the conversion between ACCESS2000 and SQL2000. I have not tried any other products yet. I hope you can experiment more and find a solution;Ii. Conversion Method1. Open "database source" in "Management Tools" under

MONGODB Data ArchitectureUpgrade SolutionProblem DiscoveryThe number of users that application servers suddenly flood into, resulting in slow server responseCheck the server and find that the response speed is extremely slow, which is 30ops.Check

When designing a database, I want to install the EA software to see if I can use EA to draw an ER model. The results show that not only can be painted, but also can be used to design a whole set of databases (generate SQL scripts ). The following

The previous blog introduced how to use the Navicat tool to back up Oracle. This blog introduced how to use the PL/SQL Developer tool to import and export Oracle databases. PL/SQL Developer is one of the main tools used by Oracle databases to import

Query all data table content Mysql> show tables; # view all tables in the current database + ---------------------- + | tables | + -------------------- + | biao | ceshi_biao | + -------------------- + 2 rows in set (0.00 sec) mysql> select * from

A transaction is a series of steps in a logical unit of work. Transactions are used to ensure the security of data operations. Transaction Features: Atomicity(Atomicity) Consistency(Stability,Consistency) Isolation(Isolation) Durability(Reliability)

When synchronizing Oracle tables to sqlserver, this error may occur when you apply data on sqlserver. 17:20:24 WARNING OGG-01154 SQL error-2147217887 mapping APPLSYS. FND_FLEX_VALIDATION_RULES to dbo. FND_FLEX_VALIDATION_RULES [SQL error-2147217887 (

Analysis of effective cursor Management   [Train of Thought Analysis] The cursor can be understood as a shared execution plan. When SQL is not shared, there are two common solutions: 1. Adjust the size of the Shared Pool (the shared execution

Scenario reproduction: The maintainer wants to use the plsql developer tool to view the data of a table a year ago. There are about rows of data in the table. Because there is no service at this time, the maintainer closes the application. When you

For example, there are two phases in table 1 and table 2, and you want to use like for join queries // use concat to connect the string select t1.id, t1.title, t2.keyword from t1 inner join t2 on t1.title like concat ('%', t2.keyword, '% ');//

Introduction: Redis is a memory-based database. It also provides several persistent solutions that allow users to write data in the memory to the local file system for use after the next restart or after the host. This article describes how to set

When writing an SQL statement into a database To_date ('20140901', 'yyyymmddhhmms ') Reporting ORA-01810: The format code appears twice The reason is that the year, month, and day expressions in java are different from those in oracle.

Zookeeper SQL Server online consultantsCame guest SS an interesting scenario where one of our client was unable to restore a native SQL Server backup successfully saved from one instance running on Machine A on another instance of SQL Server running

1. Assign "system permissions" to someone"SQL> grant connect to aobama with admin optionThis means that the admin database connection permission is granted to "aobama", and "aobama" can grant this permission to others.2. Questions about permission

Paip. How to resolve the problem of importing data into mysql# --- Cause: mysql import tool bug# --- Solution: Double quotation marks are not included in the phonetic alphabet.Author old wow's paw Attilax iron, EMAIL: 1466519819@qq.comReprinted

--- Create a tableCreate table TESTTABLE(Id1 VARCHAR2 (12 ),Name VARCHAR2 (32))Select t. id1, t. name from TESTTABLE tInsert into TESTTABLE (ID1, NAME)Values ('1', 'hangsan ');Insert into TESTTABLE (ID1, NAME)Values ('2', 'lisi ');Insert into

A ORA-00997 is reported when you access the long field of a table through dblink. for example, I want to access the remote ELISDATA through dblink. in the POS_TEST_CASE_AMASS table, where the CASE_PARAM_CHAR field is LONG, some conversions are

The following error occurs when rman backs up archivelog: RMAN> backup archivelog all delete input; Starting backup at 14-APR-14 Current log archived Using channel ORA_DISK_1 Using channel ORA_DISK_2 RMAN-00571: ======================================

The following error is reported: Mon Mar 31 18:45:59 2014Errors in file/Oracle/app/oracle/diag/rdbms/zscims/zscims2/trace/zscims2_ora_11403518.trc (incident = 28382 ):ORA-00600: Internal error code, parameter: [kqlnrc_1], [0x7000003F55C3B60], [], [],