There is no scott account in PLsql/Oracle database, how to create and unlock it

Of course, first of all, install Oracle 11g Then there should be sqlplus, which should be matched with Oracle11g Enter the main topic, if oracle/plsql does not have a scott account, how to create First find soctt.sql in the Oracle installation directory What I am doing is: E:\app\91959\product\11.2.0\dbhome_1\admin If soctt.sql is not ava ...

Posted on Sat, 09 Nov 2019 13:26:45 -0800 by inerte

Java APACHE Commons IO copying files

Last article: Java (III) APACHE Commons IO general operation   Example 1: copying files 1 import java.io.File; 2 import java.io.IOException; 3 4 import org.apache.commons.io.FileUtils; 5 6 public class Main { 7 8 public static void main(String[] args) throws IOException { 9 System.out.println(System.getPrope ...

Posted on Thu, 31 Oct 2019 12:40:34 -0700 by daz1034

AES encryption and decryption using Java

1. introduction AES, Advanced Encryption Standard, also known as Rijndael encryption in cryptography, is a block encryption standard adopted by the federal government of the United States. This standard is used to replace the original DES, which has been analyzed by many parties and widely used all ...

Posted on Tue, 29 Oct 2019 08:11:40 -0700 by quasiman

MySQL FEDERATED engine introduction

Preface: In practice, we may encounter some tables that need to operate other database instances, but we do not want to connect multiple databases. At this point we need to use data table mapping. Just like DBlink in Oracle, people who have used Oracle DBlink database link know that they can query data across instances. Similarly, the FEDERATED ...

Posted on Mon, 28 Oct 2019 19:32:39 -0700 by Michdd

Three layer architecture data access layer business logic layer presentation layer

Three tier architecture Data access layer Business logic layer Presentation layer Convenient for team development and code reuse It does not belong to three levels, but is closely related to three levels - entity class (class corresponding to database table) Data access layer Connect to databas ...

Posted on Sun, 20 Oct 2019 08:06:24 -0700 by dylan001

Oracle 11g on ECS test practice - Installation

I. environment introduction1.ECS uses 1-core 2G, system and data disk 20G respectively.2.OS uses CentOS7.63.Oracle uses 11.2.0.44. Storage Planning: in the system disk, / oradata and / orabackup occupy 10G space respectively, and the storage device uses the above separate data disk.Two, installation1. Configuration environmentIt's very convenie ...

Posted on Sat, 19 Oct 2019 11:09:42 -0700 by xposed

How Oracle Regulates Cleaning v$archived_log Records

There are many V $archived_logs on the stand-alone instance, and there are tens of thousands of records, so you have to clean them up, otherwise every query will be scrolled directly. SQL> select sequence#,applied from v$archived_log order by sequence# ; SEQUENCE# APPLIED .................... SEQU ...

Posted on Sun, 13 Oct 2019 07:48:10 -0700 by mk1200

Oracle database backup and restore Notes

There are three ways of Oracle backup and restore. They are export/import, hot backup and cold backup. Export/import is a logical backup, while hot and cold backups are physical backups. [References( https://blog.csdn.net/happylee6688/article/details/13620937]) Only the way the export/import backups and restores are recorded here. In the actual ...

Posted on Sat, 12 Oct 2019 02:48:38 -0700 by warmwind

Binary package installation MySQL database

1.1 Binary Pack Installation of MySQL Database 1.1.1 Pre-installation preparation (specification) 1 [root@Mysql_server ~]# mkdir -p /home/zhurui/tools ##Create the specified toolkit storage path 2 [root@Mysql_server ~]# wget http://Ftp.ntu.edu.tw/pub/MySQL/Downloads/MySQL-5.5/mysql-5.5.32-linux 2.6- ...

Posted on Wed, 09 Oct 2019 05:11:46 -0700 by richrock

Ali Open Source Data Synchronization Tool--DataX

  Ali Open Source Data Synchronization Tool--DataX What is it? : Offline Synchronization Tool for Heterogeneous Data Sources What can we do? : It can synchronize data between MySQL sqlServer Oracle Hive HBase FTP stably and efficiently.   Design ideas: Network Connection - "Star Connecti ...

Posted on Tue, 08 Oct 2019 00:14:34 -0700 by programming.name