Oracle Common Operations

Some of the operations that Oracle uses are documented:

1. Steps to establish tablespace and User: User establishes:create user  user name  identified by  "password"; authorization:grant create  session to  User name;            grant  create table to   User name;             grant create tablespace to   User name;             grant create view to   User name;                          2. tablespace table space (typically a table space with n stored data and an index space):create tablespace  table space name datafile  '   path (to build the path first) \** *.dbf   '  size *Mtempfile  '   path \***.dbf  '  size *mautoextend on   --Auto-growth-There are also some commands for defining size, see need  default storage ( initial 100k, next 100k,); Example: Creating Table Spaces CREATE TABLESPACE&NBsp;demospace datafile  ' e:/oracle_tablespaces/demospace_tbspace.dbf '  size 1500M  autoextend on next 5m maxsize 3000m; to delete a table space drop tablespace demospace  Including contents and datafiles3. User rights grant users permission to use tablespaces:alter user  username  quota  unlimited on  table space;  alter user  user name  quota *M on  tablespace; 4.--table Space Create  TABLESPACE sdtDATAFILE  ' F:\tablespace\demo '  size 800M          EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;  --Index Table Space create tablespace sdt_indexdatafile  ' F:\tablespace\demo '  size 512M                   extent  management local segment space management auto;     -- 2. Build User Create user demo identified by demo default tablespace demo; --3. Empowering Grant connect, resource to demo;grant create any sequence to demo;grant create  Any table to demo;grant delete any table to demo;grant insert  any table to demo;grant select any table to demo;grant  Unlimited tablespace to demo;grant execute any procedure to demo;grant  update any table to demo;grant create any view to demo;5.-- Import Export command    ip Export method: exp demo/[email protected]:1521/orcl file=f:/f.dmp  Full=yexp demo/[email protected] file=f:/f.dmp full=yimp demo/[email protected]  file=f:/f.dmp full=y ignore=y6.--Creating a data link create database link ygbgtest_portaltest_ link   connect to portal identified by portal   using  ' (description =       (address_list =        (address =  ( PROTOCOL = TCP) (host = 192.168.104.102) (port = 1521))       )       (connect_data =        (service_ NAME = ORCL)      )        select *  from [email protected]_portaltest_link;   7.--creating temporary tables to get remote table data     Create global temporary table temp_ygbg_information on commit preserve  rows as select * from [email protected]_portaltest_link;select count ( 1)  from temp_ygbg_information t;select * from temp_ygbg_information;8.-- Inserting data into the destination table from a staging table Insert into portal_information   (Id,   title,   picture_url,   status,    author_id,   author_name,   create_time,    modify_date,   delete_date,   view_num,   order_flag,    summary,   type,   promulgation_charge,   information_ Source,   sort_num,   sub_title,   is_slidenews)  select     seq_portal_information. nextval,   title,   picture_url,   status,    author_id,   author_name,   create_time,   modify_date,    delete_date,   view_num,   order_flag,   summary,    type,   promulgation_charge,   information_source,&nBsp;  sort_num,   sub_title,   is_slidenews from temp_ygbg_ information t1 where t1.id=3338;

This article is from "Angry snail" blog, please make sure to keep this source http://yangxianhong.blog.51cto.com/5707396/1561984

Oracle Common Operations