![]() ![]() *).īy the way, I use *PL/SQL Developer* to export this format's data (*insert. ![]() SQL> select blocks,num_rows from user_tables where table_name = 'TEST1' ĭue to my another db is *MySQL 5.7*, thus I don't use *EXPDP/EXP* to export test table *test1* on Oracle DB and I just use *SPOOL* to export pure SQL data (format *CSV* or *insert. SQL> select sum(blocks),sum(bytes)/1024/1024 size_mb from user_segments where segment_name = 'TEST1' and segment_type = 'TABLE' " (it's better to split up a few small files because the file which I had exported last time is approximately 40 GB, and I didn't open it for viewing via UltraEdit or EditPlus )?Īccording to your video, currently I've created a test table *test1* and my SQL code is as follows, (2) how to rapidly export those tables via CSV or "insert. (1) how to generate some test tables (particularly, data size is very huge like mine previous)? The following is those three tables' numbers of row and data size ( case and res are partition table and map is not),ĭue to all of tables above (table name has been replaced) comes from Production Environment, hence I wanna seek advice for 2 questions, I didn't endured this very slowly exporting speed. " for giving another App teams (their database is MySQL 5.7) once again, I remembered that I used PL/SQL Developer (or SQL Developer) to export those tables with two formats previous on "Apr 12th, 2018" last time and it spent more than 8 hours exporting completely. Our Developer manager asks me to export Oracle production database's three big tables with CSV or this format "insert. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |