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

Make a note of some of the common actions in Oracle:

1. Steps to establish tablespaces and users: user establishment: create user username identified by "password"; authorization: grant create session to username; grant create table to username; grant create tablespace to username; grant create view to username; 2. Create tablespaces (generally create N tablespaces and one index space for storing data): create tablespace tablespace name datafile 'path (to build the path first)\ * * .dbf' size * Mtempfile 'path\ * * .dbf' size * Mautoextend on-- there are also some commands to define the size, see default storage (initial 100K, next 100k,) Example: create the tablespace create tablespace DEMOSPACE datafile'EVERUR size drop tablespace DEMOSPACE including contents and datafiles3. DBF 'TBSPACE.dbf'TBSPACE5M maxsize 3000M; delete the tablespace drop tablespace DEMOSPACE including contents and datafiles3. User permissions grant users the right to use tablespaces: alter user username quota unlimited on tablespace; or alter user username quota * M on tablespace; 4. CREATE TABLESPACE sdtDATAFILE'F:\ tablespace\ demo' size 800m EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;-indexed tablespace 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. Weighted 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. Ip-import and export commands: exp demo/demo@127.0.0.1:1521/orcl file=f:/f.dmp full=yexp demo/demo@orcl file=f:/f.dmp full=yimp demo/demo@orcl file=f:/f.dmp full=y ignore=y6.-- creates data link create database link ygbgtest_portaltest_link connect to portal identified by portal using'(DESCRIPTION = (ADDRESS_LIST = (PROTOCOL = TCP) (HOST = 192.168) .104.102) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = orcl)' Select * from portal_information@ygbgtest_portaltest_link; 7.Muir-create a temporary table to get remote table data Create global temporary table temp_ygbg_information on commit preserve rows as select * from portal_information@ygbgtest_portaltest_link;select count (1) from temp_ygbg_information t select * from temp_ygbg_information 8. Mel-insert data from temporary table into destination 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, sort_num, sub_title, is_slidenews from temp_ygbg_information t1 where t1.id=3338

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.