Read about oracle autonomous database cloud, The latest news, videos, and discussion topics about oracle autonomous database cloud from alibabacloud.com
user password format:
Alter user username identified by new password;
(2) Use user system login Pl/sql Developer, create tablespace and user
Create tablespace casic_smart datafile ' C:\oracle\product\10.2.0\oradata\orcl\casic_smart.dbf ' size 1000m;
Create user Tianzhi_smart identified by tianzhi_smart default Tablespace casic_smart quota 500m on users;
Grant all privileges to tianzhi_smart;
4. Converting databases via
Label:Server uses Azure Cloud Platform server, unable to log in RDP after shutting down the reboot yesterdayMy heart broke down at that time.Fortunately, the server on the business night can be shut down, the second day, 7 in the morning, the server configuration has been re-adjusted, or reported the same error.Submit case to the century interconnection, in the sense of hopelessness, I began my work.1. Use azcopy to copy my system disk and disk.2. Cre
Today found a small thing, feel very interesting, look for some information to share with you:
In the Sqlplus:
Tools provided by third parties (e.g. Plsqldev)
Summarize:
exec is a sqlplus command that can only be used in Sqlplus.
Call is an SQL command, any tool can be used, call must have parentheses, that is, an example without parameters
Call must have parentheses, in which case there is no parameter
idle> connect/as sysdba
is connected.
sys@po10>
sys@po10> CREATE PROCEDURE
Nonsense not to say more, directly to everyone to paste the key code, the specific code as follows:
Package com.sp.test;
Import java.sql.*;
Import java.util.*;
public class Text_lianxi extends Thread {public void run () {try {yunxing ();
Thread.Sleep (10000);
The catch block (Interruptedexception e) {//TODO automatically generated catch blocks E.printstacktrace ();}
Input function Public string[] Shuru () {System.out.println () Enter the details of the examinee in order: \ n Test grade, I
-the main process for sending a message is as follows:
Procedure Send_mail_ (P_from Varchar2,--mail Sender P_fromuser Varchar2,--Sender nickname P_touser Varchar2,--recipient nickname P_to Varchar2,--Postal Recipient P_CC VARCHAR2,--CC p_subject VARCHAR2--Message header P_message Varchar2,--mail content P_user Varchar2,--Message authentication user P_mailhost VAR CHAR2,--mail service address P_PSD Varchar2--mail authentication password) is V_conn utl_smtp.connection; --The connection to t
2016-08-11 Chen Long-mo College Explore Oracle High water level impact on database performance1Hello everyone! I am a chen long from the cloud and Emme, and I am currently primarily responsible for Oracle technical support work. When I began to learn Oracle, listen to Eygle
First, describe
To install the ORACLE11GR2 database in a 64-bit Win7 operating system, we first need to download the Oracle database software, which contains 32-bit and 64-bit Oracle database software.
Baidu Cloud
How do you manage Oracle databases for a novice Oracle database? First of all, from the simplest startup and shutdown database, the following is a brief introduction to the sequence of starting and closing Oracle databases.
First, the Oralce start order:
1. Start the liste
\11.2.0\dbhome_1\bin>sqlplus/as SYSDBA
Sql*plus:release 11.2.0.1.0 Productionon Wednesday December 21 10:56:26 2016
Copyright (c) 1982, Oracle. All rights reserved.
Connect to:
Oracle Database 11g Enterprise editionrelease 11.2.0.1.0-64bit Production
With the partitioning, OLAP, Data miningand Real application testing options
Sql>
3) Start
Sql>startup
Wh
normal.
Path:d:\app\administrator\product\11.2.0\client_1;d:\app\administrator\product\11.2.0\dbhome_1\bin; ...
The fourth is Oracle_sid (ORCL instance name, which is the name of the database at installation time)
Oracle_sid:orcl
The fifth one is oracle_home.
Oracle_home: You can not set, if the settings must be correct, otherwise can not be used.
If you forget the instance name at Oracle installatio
is known as the above 10.69.1.11 IP attempt multiple failed login caused by the lock
Note:
The normal database defaults to locking the user after 10 unsuccessful attempts
1, view the value of failed_login_attempts
SELECT * FROM Dba_profiles
2, modified to 30 times
Alter profile default limit failed_login_attempts 30;
3. Change to unlimited times (for security reasons, not recommended)
Alter profile default limit
default is *, if you want to find the backup dump file, the format is *.DMP
/d file modification time before or after a certain time. -3 indicates a file 3 days ago.
/s contains subdirectories
/C represents a command to be executed for each file, which can be "cmd/c del/f/s/q @file" If you want to delete the file. Where the variable @file indicates that the file name F S Q indicates that forced silent deletion can not be used; cmd/c represents executing a string-specified command and then br
interface shown below
Figure 2 The results of the successful connection show
(2) to start creating a table, we create a simple table about news information, which contains the following information:
Figure 3 The information table that you want to create
The following table is created: Left click on the database connection name to build the table open, in the "Table (filtered)" option to right-click Select "New Table", and then the New Table d
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.