oracle ³£ÓÃÃüÁî

exp test_1209/test_1209@127.0.0.1/orcl tables=(TEST_INDEX) file=d:\test_index.dmp

exp test_1209/test_1209@127.0.0.1/orcl tables=(TEST_INDEX) file=d:\test_index.dmp rows=n

exp aqsc_1221/aqsc_1221@192.168.1.97/orcl rows=y indexes=n compress=n STATISTICS=none GRANTS=n TRIGGERS=n CONSTRAINTS=n buffer=65536 feedback=100000 file=aqsc_1221_0530.dmp log=aqsc_1221_0530.log tables=act_ge_bytearray,act_ge_property,act_hi_actinst,act_hi_attachment,act_hi_comment,act_hi_detail,act_hi_identitylink,act_hi_procinst,act_hi_taskinst,act_hi_varinst,act_id_group,act_id_info,act_id_membership,act_id_user,act_re_deployment,act_re_model,act_re_procdef,act_ru_event_subscr,act_ru_execution,act_ru_identitylink,act_ru_job,act_ru_task,act_ru_variable

imp aqsc_0305/aqsc_0305@127.0.0.1/orcl file=aqsc_1221_20190529.dmp log=aqsc_1221_20190529.log full=y

imp aqsc_0305/aqsc_0305@127.0.0.1/orcl file=aqsc_1221_20190529.dmp log=aqsc_1221_20190529.log full=y ignore=y

imp aqsc_1221/aqsc_1221@127.0.0.1/orcl file=aqsc_1221_0618.dmp log=aqsc_1221_0618.log tables=(sys_menu)

create view ZT_TRAFFICCOMPANY as select * from FSZHATU.ZT_TRAFFICCOMPANY;

create table zt_car as select * from fszhatu.zt_car 1=2

----
----012.xf_file:ÏîÄ¿¸½¼þ
----drop   table xf_file;
create table xf_file(
	id	VarChar2(50)	Not Null	,	--id:Ö÷¼ü
	type	VarChar2(20)		,	--type:ÀàÐÍ(ÊֲᡢÎÄÊéµÈ)
	sx	Number(9)		,	--sx:˳Ðò£¨±£Áô½Ó¿Ú£©
	gcxx_id	VarChar2(50)		,	--gcxx_id:¹¤³ÌÐÅÏ¢id£¨±£Áô½Ó¿Ú£©
	gcxx_form_id	VarChar2(50)		,	--gcxx_form_id:ÎÄÊéid£¨±£Áô½Ó¿Ú£©
	name	VarChar2(50)		,	--name:ÎļþÃû³Æ
	ext	VarChar2(20)		,	--ext:Îļþºó׺
	path	VarChar2(100)		,	--path:Îļþ·¾¶
	create_date	Date	Not Null	,	--create_date:´´½¨Ê±¼ä
	create_by	VarChar2(50)	Not Null	,	--create_by:´´½¨Õß±êʶ
	update_date	Date		,	--update_date:¸üÐÂʱ¼ä
	update_by	VarChar2(50)		,	--update_by:¸üÐÂÕß±êʶ
	remarks	VarChar2(250)		,	--remarks:±¸×¢ÐÅÏ¢
	del_flag	Number(4)			--del_flag:ɾ³ý±ê¼Ç
)
;

alter table XF_FILE add constraint PK_XF_FILE primary key(ID) ;


comment on table XF_FILE			is	'xf_file:ÏîÄ¿¸½¼þ';

comment on column xf_file.id 			is	'id:Ö÷¼ü';
comment on column xf_file.type 			is	'type:ÀàÐÍ(ÊֲᡢÎÄÊéµÈ)';
comment on column xf_file.sx 			is	'sx:˳Ðò£¨±£Áô½Ó¿Ú£©';
comment on column xf_file.gcxx_id 			is	'gcxx_id:¹¤³ÌÐÅÏ¢id£¨±£Áô½Ó¿Ú£©';
comment on column xf_file.gcxx_form_id 			is	'gcxx_form_id:ÎÄÊéid£¨±£Áô½Ó¿Ú£©';
comment on column xf_file.name 			is	'name:ÎļþÃû³Æ';
comment on column xf_file.ext 			is	'ext:Îļþºó׺';
comment on column xf_file.path 			is	'path:Îļþ·¾¶';
comment on column xf_file.create_date 			is	'create_date:´´½¨Ê±¼ä';
comment on column xf_file.create_by 			is	'create_by:´´½¨Õß±êʶ';
comment on column xf_file.update_date 			is	'update_date:¸üÐÂʱ¼ä';
comment on column xf_file.update_by 			is	'update_by:¸üÐÂÕß±êʶ';
comment on column xf_file.remarks 			is	'remarks:±¸×¢ÐÅÏ¢';
comment on column xf_file.del_flag 			is	'del_flag:ɾ³ý±ê¼Ç';

create tablespace test_data
logging
datafile 'C:/app/Ray/oradata/orcl/TEST_DATA.dbf'
size 200m
autoextend on next 100m
maxsize 2048m
extent management local;

drop tablespace test_data
including contents and datafiles
cascade constraints;

create user test_1209 --̞
identified by test_1209 --ÃÜÂë
default tablespace test_data --ĬÈϱí¿Õ¼ä
grant dba to test_1209 --¸øȨÏÞ

grant dba to test_1209;

grant select on table1 to user1;

drop user test_1209 cascade;

select * from dba_users;

truncate table act_hi_actinst;
truncate table act_hi_detail;
truncate table act_hi_identitylink;
truncate table act_hi_procinst;
truncate table act_hi_taskinst;
truncate table act_hi_varinst;
truncate table act_ru_event_subscr;
truncate table act_ru_execution;
truncate table act_ru_task;
truncate table act_ru_variable;
truncate table act_ru_event_subscr;
truncate table act_ru_execution;
truncate table act_ru_identitylink;
truncate table act_ru_job;


delete from act_ru_task;
delete from act_ru_identitylink;
delete from act_ru_variable;
delete from act_ru_event_subscr;
delete from act_ru_execution;

create index index_hist_sr on ZT_POSITION_HIST (SYNCHRO_DATE, RECEIVE_DATE);
create index index_hist_rd on ZT_POSITION_HIST (RECEIVE_DATE);
create index index_hist_PRM on ZT_POSITION_HIST (R_PLATE_NUMBER);

select *
from USER_INDEXES
where TABLE_NAME = 'ZT_POSITION_HIST';

select *
from user_ind_columns
where table_name = 'ZT_POSITION_HIST'
  and column_name = 'RECEIVE_DATE';

select 'INSERT INTO TEST_INDEX (ID,A,B,C)
 VALUES(' || '''' || ID ||'''' || ','
|| '''' || A || '''' || ','
|| '''' || B || '''' || ','
|| '''' || C || '''' || ');'
 From TEST_INDEX order by ID