scott brinker

Reprint: http://www.cnblogs.com/xqzt/p/5034375.htmlFor those who are familiar with Oracle or who have contacted Oracle, Scott, the user, must be quite familiar with it. 12c has launched a pluggable database with multiple database PDB in the form of multiple tenants in a single container cdb. The PDB does not include the Scott user by default.To do a data pump experiment, you need a test user, so you need to

Oracle 10gExploitationUtlsampl. SQLCreateScott userAnd sample data are the main content we will introduce in this article. We know that many demo programs use the tables of scott users and their users as examples. Therefore, quick creation of this user and data in the initialization table are required. In the Oracle 10 Gb environment, this process is very simple. You only need to run the $ ORACLE_HOME/rdbms/admin/utlsampl. SQL script as a sys user. Th

In oracle9i10g, if the database instance does not have the scott mode, you can manually create it as follows: In oracle 9i/10g, if the database instance does not have the scott mode, you can manually create it as follows: In Oracle 9i/10g, if the database instance does not have the scott mode, you can manually create it as follows: Log on to the database

Post address: http://hi.baidu.com/zhangxia6110/blog/item/a4e2aa0001c3a483e850cd74.html In PLSQL developer, the ora-28000 the account is locked is prompted when you log on with Scott/tiger. Solution: After Oracle10g is installed, use Scott/tiger for testing. The following error message is displayed:Oracle10g the account is lockedOracle10g the password has expiredCause:

The preceding two figures show the normal operation of scott user and test data after inserting c ~~~ Start the process. 1. Start -- run -- cmd Input: sqlplus/as sysdba connecting to database 2. Create a c # scott user CREATE USER c##scott IDENTIFIED BY tiger ;3. Authorize the user GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO c##scottCONTAINER=ALL ;4. S

Sqlplus on the command line.Log in as system, password is the system you setC:\users\administrator>sqlplusSql*plus:release 10.2.0.1.0-production on Tuesday October 14 21:29:23 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Please enter user name: SystemEnter Password:Connect to:Oracle Database 10g Express Edition Release 10.2.0.1.0-productionAfter creating the user Scott password for tigerSql> create user

1. First, the Scott account needs to be unlocked and entered: Alter user Scott account unlock; At this point, the Scott accounts are expired and the password expires (expired);2. Then, check the Scott account validity period, enter: SELECT * from Dba_profiles s where s.profile = ' default ' and resource_name = ' passwo

Tags: database Oracle sqlThe above two figures are inserted into C # #scott用户及其测试数据后的正常运行图 ~ ~ ~Begin the process of introduction.1. Start-run--cmdInput: Sqlplus/as SYSDBA connect to Database2. Create a C # #scott用户CREATE USER C # #scott identified by Tiger;3. Authorizing the userGRANT connect,resource,unlimited tablespace to C # #scottCONTAINER =all;4. Set the t

Oracle unlocks SCOTT/TIGER users 1. Verify the current system status for SCOTT users:Select * from dba_users where upper (username) = 'Scott ';ACCOUNT_STATUS: EXPIRED LOCKED2. Unlock SCOTT users:Conn sys/bitservice @ ttonline as sysdba;Alter user scott account unlock;Selec

Yesterday, I suddenly found that the Oracle server I installed does not have scott users, so I cannot import it manually. Specific Method: First, log on with the system user. Import the scott. SQL script (which can be found in the oracle installation directory). For example, import the local path and write it as follows: @ D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ RDBMS \ ADMIN \

Oracle provides the scott user's re-creation script, and the 11G uses the script to create scott. The simple operation is as follows: SQL> select * from dba_users where username = 'Scott '; ------ SCOTT has been manually deleted. No rows selectedSQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release

Oracle provides the scott user's re-creation script, and the 11G uses the script to create scott. The simple operation is as follows: SQL> select * from dba_users where username = 'Scott '; ------ SCOTT has been manually deleted. No rows selected SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Relea

Label:After the successful installation of the Oracle database, the first use of the following problem occurs, Here are just 3 ways to do this: L Sql*plus L OEM Control console L Windows Console 1. Take the Windows console as an example A. Run the cmd command as an administrator B. Enter "Sqlplus/nolog" C. Enter "Conn/as sysdba" C. Enter "Startup" 2. Take Sql*plus as an example A. Preparation First use Sql*plus to connect to Oracle "Sqlplus/nolog" starts sql*plus in a way that does not conn

① log in to the database with the ' sys ' user, enter select * from dba_users; see if there are any Scott users, as shown in:650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/9D/5E/wKioL1l-8maBmLr0AABqgUF9CR8135.png "title=" Qq20170731170210.png "alt=" Wkiol1l-8mabmlr0aabqguf9cr8135.png "/> As shown, the Scott user does not exist.② because the operating system is Linux, log in to the Linux interfa

Because the concept of CDB and PDB is introduced in the ORACLE12C database (refer to the article http://www.cnblogs.com/kerrycode/p/3386917.html of Xiaoxiang Hermit for details), The Scott/tiger account we used to practice SQL statements is placed in the PDB, and when we link to a 12c database, the default is login CDBThis has led to a lot of practical oracle12c database Novice can not find the familiar Scott