The data quantity is large, after a day of floating car data import database has reached 77.5 GB DBF file, now I'll be the first to put these data to the vehicle id as the unit filtered and then deposited in the vehicle id as the table name in the new table, manual processing is too slow and error-prone, ask ace to guide how to use the cursor loop to realize the automatic processing, thank you very much!!!!!! Online answer, such as
Ps (I use the create table 11243 in TABLESPACE JRD_GPS as select * from SYSTEM. TB_GPS_1202 where VEHICLE_ID=11243
The order by speed_time can create out of the taxi all form id 11243 a day, with a select distinct vehicle_id from SYSTEM. TB_GPS_1202 elected probably more than 8000 data)
CodePudding user response:
Always an error, please correct me, tried a variety of methods or error,CodePudding user response:
Trial and error, finally success, share:- Created on 2015/7/16 Thursday by CM
Declare
STR varchar2 (1000);
Taxiid varchar2 (10) :=';
Cursor taxiid is the select VEHICLE_ID from alltaxi;
The begin
For cp in taxiid
Loop
Taxiid:=cp. Vehicle_id;
STR:='create table TAXI' | | taxiid | | 'in TABLESPACE TAXI as select * from SYSTEM. TB_GPS_1202 where VEHICLE_ID=' | | tablename | | 'order by speed_time';
The execute immediate STR;
End loop;
The end;
CodePudding user response:
LZ how to put the business data in the system under the user? The other are suggested to create a user,
CodePudding user response:
The original poster hello, recently doing a school subject, would like to ask you where is the taxi GPS data from the receive, thank you very muchCodePudding user response:
CodePudding user response:
Senior hello ~ recently doing projects need some taxi trajectory coordinates data, can you share with me some ~! Thank you very much! My email is [email protected]CodePudding user response:
Table name cannot be all Numbers, also note