創(chuàng)建同義詞
conn tt/bitservice@sw00058 ;
grant select on vw_rightpeople to account;?? //先授權
conn account/bitservice@sw00058 ;
create or replace synonym vw_rightpeople for tt.vw_rightpeople;??? //創(chuàng)建同義詞

exp1:
connect pubr/bitservice@account ;
grant select on orgpeople to account;
connect account/bitservice@account ;
create or replace synonym orgpeople for pubr.orgpeople;

exp2:
conn pubr/bitservice;
grant select on allactive to archive;??
conn archive/bitservice;
create or replace synonym allactive for pubr.allactive;??

創(chuàng)建索引
conn pubr/bitservice@sw00058 ;
create index pubr.idx_taxfeedetail_tfdefineid on pubr.taxfeedetail (taxfeedefineid)

創(chuàng)建序列號sequence
create sequence seq_account_taxfee

創(chuàng)建用戶
-- Create the user
create user AP? identified by;
-- Grant/Revoke object privileges
grant select, insert, update, delete, references, alter, index on RECEIVETAX to AP; //授權

創(chuàng)建角色
-- Create the role
create role CONNECT;
-- Grant/Revoke system privileges
grant alter session to CONNECT;????????? //角色授權
grant create cluster to CONNECT;
grant create database link to CONNECT;
grant create sequence to CONNECT;
grant create session to CONNECT;
grant create synonym to CONNECT;
grant create table to CONNECT;
grant create view to CONNECT;

創(chuàng)建存貯地址
-- Create directory
create or replace directory MEDIA_DIR
? as 'E:\oracle\ora92\demo\schema\product_media\';

創(chuàng)建library
-- Create library
create or replace library SYS.DBMS_XMV_LIB
? as '';

創(chuàng)建觸發(fā)器
create or replace trigger tri_Invoice_biud
?before insert or update of realtypeid,flowid,applytime,mastatus,bastatus or delete on Invoice for each row
declare
?l_cnt number(8);
begin
.......
end;

創(chuàng)建數(shù)據(jù)類型
types
type bodies

創(chuàng)建包
create or replace package account_taxfeedata as
? type p_receiveTaxIDs is table of account_TaxFee.receiveTaxID%type index by binary_integer;
? type p_goodsids is table of account_TaxFee.goodsid%type index by binary_integer;
? v_receiveTaxIDs p_receiveTaxIDs;
? v_goodsids p_goodsids;
? v_NumEntries binary_integer := 0;
end account_taxfeedata;

?

創(chuàng)建過程
create or replace procedure buildTable_afterSelect(pmMainTable in varchar2,pmStanID in number,pmRealTypeID in number,pmActID in number,pmBldroomID in number)
as
?l_category?number(8);
?l_parentid realotherright.parentid%type;
begin

end;

創(chuàng)建函數(shù)
create or replace function func_syncTaxfeeData(pOpertype number,pAccid number) return varchar2 is
? Result varchar2(2000);
? l_url? varchar2(2000);
? l_uid? varchar2(20);
? l_pwd? varchar2(100);
? l_ret? varchar2(2000);
begin
? return(Result);
end func_syncTaxfeeData;

?

給sequence創(chuàng)建synonym，并授予select權限
connect 用戶1/密碼@實例名 ;
grant select on seq_ma_realsalepermit_multiid to archive;
connect 用戶2/密碼@實例名;
create or replace synonym seq_ma_realsalepermit_multiid for aestate.seq_ma_realsalepermit_multiid;??

?

創(chuàng)建job

select job,what,last_date,next_date,next_sec,BROKEN,INTERVAL,FAILURES,INSTANCE from user_jobs;
若job不存在（看what是否是pck_report_getreportdata.proc_getreport_forjobexec; proc_CreateAllStreportData(1)），建議通過以下語句創(chuàng)建job：

variable testjobid number;
-- 創(chuàng)建job
begin
? dbms_job.submit(:testjobid,'proc_CreateAllStreportData(1);',trunc(sysdate)+18/24,'trunc(sysdate)+1+18/24');
end;
/
show err;

oracle 創(chuàng)建數(shù)據(jù)庫對象