一、新建表
通过在pl/sql中,右击Tables,新建
![](https://images2017.cnblogs.com/blog/1195748/201712/1195748-20171222143917396-1705187292.png)
二、导出表
1、导出dmp
工具-导出表
![](https://images2017.cnblogs.com/blog/1195748/201712/1195748-20171222144029303-463693898.png)
工具-导入表
![](https://images2017.cnblogs.com/blog/1195748/201712/1195748-20171222144036240-760319021.png)
2、导出sql
工具-导出表
![](https://images2017.cnblogs.com/blog/1195748/201712/1195748-20171222144042850-814371576.png)
工具-导入表
![](https://images2017.cnblogs.com/blog/1195748/201712/1195748-20171222144049896-1678705538.png)
三、导出空表报错
方法1:toad修改
toad登录SYS 密码orcl
Database-Schema Browser
![](https://images2017.cnblogs.com/blog/1195748/201712/1195748-20171222144358225-1749939423.png)
Users-右击-alter-alter system set deferred_segment_creation=false;
方法2:使用SQL导入
工具-导出用户对象-1.sql
![](https://images2017.cnblogs.com/blog/1195748/201712/1195748-20171222144108131-56594144.png)
工具-导出表-2.sql
![](https://images2017.cnblogs.com/blog/1195748/201712/1195748-20171222144114568-1228741981.png)
工具-导入表-1.sql
工具-导入表-2.sql
![](https://images2017.cnblogs.com/blog/1195748/201712/1195748-20171222144122146-776887786.png)
四、导出视图
导出:工具-导出用户对象
导入:工具-导入表-sql插入
五、导入导出EXCEL
1、导出到excel
![](https://images2017.cnblogs.com/blog/1195748/201712/1195748-20171222144451178-330357495.png)
2、导入excel
工具-ODBC导入器,选择自定义的Excel
![](https://images2017.cnblogs.com/blog/1195748/201712/1195748-20171222144138553-873022869.png)