You may use Create Table as Select (CTAS) after adequate privileges are granted to the target user.

• 怎样将一个用户的所有表导入到另一用户中？