Content learned in: edu.aliyun.com
1. Reflection acquisition class structure
if you suddenly find that you need ...
Posted by osram on Thu, 06 Feb 2020 05:25:58 -0800
In the process of configuration, initiation and recovery of Oracle database backup, many Oracle database commands are needed. In this chapter, I will sort out the commands for your reference.
Oracle user and instance related commands
# ps -ef | grep [p]mon
orauxdb 18751 1 ...
Posted by n8r0x on Sun, 02 Feb 2020 01:09:46 -0800
A set of SQL statements used to complete specific database functions, which are compiled and stored in the database system. In use, the user calls and executes the stored procedure by specifying the defined stored procedure name and giving the corresponding stored procedure parameters, thus completing one or a series of databas ...
Posted by excessnet on Fri, 31 Jan 2020 01:19:42 -0800
The main test is what happens to expdp when a table has DML action.
This test mainly opens three windows, one is to insert data, about 100W pieces will be inserted for a long time. The second window queries the inserted data, of course, it does not query 100W pieces. In the third window, when inserting data, perform data pump e ...
Posted by danville on Wed, 29 Jan 2020 08:02:52 -0800
1. Spring Boot project adds MyBatis dependencies and Oracle drivers:
Posted by mtimdog on Sat, 25 Jan 2020 08:22:24 -0800
cp command backup is a warm, full backup, the backup process needs to maintain a global read lock, this lock is more lethal to the database, it is likely to make the database hang in production environment, so it is not recommended to use in production environment.
1. Add a global read lock to the backup library: fl ...
Posted by djopie on Thu, 16 Jan 2020 09:39:26 -0800
linux redhat6 Oracle11g rac +lvm +asm installation process summary experience
Main operating system: windows 10
Virtual machine VMware 15: Two Red Hat Enterprise linux 6.10
Package: Oracle Database software: Oracle11gR2
Cluster software: Oracle grid infrastructure 11gR2(11.2. ...
Posted by Heywood on Thu, 16 Jan 2020 01:37:19 -0800
stay MySQL How to get a list of all foreign key constraints to a specific table? Specific columns? This and The Oracle problem Same, but for MySQL.
Post old answers to add some useful information.
I have a similar problem, but I also want to look at constraint'u type and referred t ...
Posted by Bike Racer on Mon, 13 Jan 2020 18:04:15 -0800
Step 1: Check the JDK
View the JDK version and type: java-version on the command line
[root@test ~]# java -version
bash: java: command not found
As above, prove that your linux is very clean, go directly to Step 2
Or the following
[root@test ~]# java -version
openjdk version "1.8.0_102"
OpenJDK Runtime Environment (build 1.8.0_102-b14)
Posted by Cruzado_Mainfrm on Sun, 12 Jan 2020 09:33:43 -0800
1. If you need to find the records with "three" and "cat" in U ﹣ name, please use and condition
Select * from [user] where u name like '% 3%' and u name like '% cat%'
If you use select * from [user] where u name like '% 3% cat%
Although we can search for "tripods", we can't search for "Zhang ...
Posted by Mr_Mako on Mon, 06 Jan 2020 04:06:35 -0800