Shulou(Shulou.com)06/01 Report--

Download oracle

Web address http://www.oracle.com/technetwork/index.html

To download and install different versions according to your model, you must first sign up for an oracle account before you can download.

The official website EX Edition is free of charge.

My computer is 64-bit, so I chose the version.

Decompression and installation

(1)

(2)

(3)

(4)

The space I installed on disk D is big enough.

(5) enter the password to pick yourself up at will, but remember for yourself, oh, I entered 1234

(6) installation

(7)

Configure oracle

(1) start

2) sqlplus connection database user system password 1234 (previously set)

1. To establish tablespaces and users:

two。 User

3. Create: create user username identified by "password"

4. Authorization: grant create session to user name

5. Grant create table to user name

6. Grant create tablespace to user name

7. Grant create view to user name

For example:

Create: create user myuseridentified by "password"

Authorization: grant createsession to myuser

Grant create table to myuser

Grant create tablespace to myuser

Grant create view to myuser

Grant connect,resource to myuser

Grant create any sequence to myuser

Grant delete any table to myuser

Grant insert any table to myuser

Grant select any table to myuser

Grant unlimited tablespace to myuser

Grant execute any procedure to myuser

Grant update any table to myuser

1. Tablespace

two。 Create tablespaces (generally N tablespaces and one index space for storing data):

3. Create tablespace tablespace name

4. Datafile 'path (to build the path first)\ * * .dbf' size * M

5. Tempfile 'path\ * * .dbf' size * M

6. Autoextend on-automatic growth

7. There are also some commands that define the size, depending on the need.

8. Default storage (

9. Initial 100K

10. Next 100k

11.)

Example: create tablespace

Create tablespace DEMOSPACE

Datafile'D:\ soft\ oracle\ app\ oracle\ oradata\ oracle_tablespaces\ DEMOSPACE_TBSPACE.dbf'size 1500m

Autoextend on next 5M maxsize 3000M

Delete tablespace

Drop tablespace DEMOSPACE including contentsand datafiles

1. Backup database

2.-Import and export command

3. Ip export method: exp myuser/password@127.0.0.1:1521/orcl file=f:/f.dmp full=y

4. Exp myuser/pssword@orcl file=f:/f.dmp full=y

5. Imp myuser/password@orcl file=f:/f.dmp full=y ignore=y

Log in again

Log in using the user you created

Use plsql

Configure tns

LISTENER_ORCL =

(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))

Install plsql configuration oci

Log in

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.