用dbc怎样打开数据库（打开数据库xs.dbc的命令是）

科技前沿 • 2025-06-16 17:43 • 阅读 35

大家好，我是讯享网，很高兴认识大家。

 <p>登录高斯</p>

讯享网

ssh dbuser@ip

zsql sys/password@127.0.0.1:port

登录所有db

for dbname in ‘echo ${dblist} do zsql db/password@${dbname} -c “select * from table;” >${dbname}.info done 收集awr wrs list wsr snapid snapid 导出表数据 dump QUERY "select * from table" into file 'test.csv' COLUMNS ENCLOSED BY '' COLUMNS TERMINATED BY '|'; dump TABLE tablename into file 'test.csv' COLUMNS BY '' COLUMNS TERMINATED BY '|'; 导出表结构 exp tables=table1,table2 file='test.sql' content=metadata_only; 导出表数据 exp tables=table1,table2 file='test.sql' filetype=TXT content=data_only; exp导出大量表 aaa.txt 里是表名列表 table1,table2 tablelist=$(cat aaa.txt)

zsql db/password@ip:port -c “exp tables=${tablelist} file=”exp.txt“”;

SQL

删除表

drop table tablename

删除记录

delete from tablename

清空表

讯享网

truncate table tablename

备份表

creat table tt_bak as select * from tt

查询

select count(1),substr(col,-2),to_char(time,’YYYYMMDDHH24‘) from tblname group by substr(col,-2),to_char(time,’YYYYMMDDHH24‘) having count(1)>1000 order by to_char(time,’YYYYMMDDHH24‘);

函数

upper

to_date(’2024/05/08‘,’YYYY/MM/DD‘)

to_char(time,’YYYYMMDDHH24‘)

substr(val,-2)

查看数据库占用空间最大的20个表

select segment_name,q

segment_type,bytes from my_segments order by bytes desc limit 20;

索引空间回收

alter index indexname unusable

alter index indexname rebuild online

用dbc怎样打开数据库（打开数据库xs.dbc的命令是）

相关推荐