[大数据]Oracle数据库操作注意事项

在服务端导入数据时，不小心退出了CMD，如何停止数据的导入
impdp 用户名（ykt/ykt） attach= SYS_IMPORT_TABLE_01回车
stop_job=immediate回车

drop tablespace GJCARD 删除表
drop tablespace GJCARD including contents and datafiles;
drop tablespace GJCARD including contents and datafiles csacade constraints;

在紫色软件中操作数据时，SQL语句为

select BUSID，LINEID,TRADEDATETIME,BUSNAME,STATIONNAME,STATIONID from CARDINFO where LINEID=612 or LINEID=622;

select BUSID，LINEID,TRADEDATETIME,BUSNAME,STATIONNAME,STATIONID from CARDINFO;

select BUSID，LINEID,TRADEDATETIME,BUSNAME,STATIONNAME,STATIONID from CARDINFO_11 where LINEID=43;

select BUSID，
LINEID,TRADEDATETIME,BUSNAME,STATIONNAME,STATIONID from CARDINFO_11 where TRADEDATETIME=‘2019/10/11’ AND LINEID=43;