1.选择物理模型视图Physical:
[img]http://dl.iteye.com/upload/attachment/0068/3488/2d72b784-6c9a-3d95-8658-b51aeb56af25.png[/img]
2.选择Tools -> Forward Enginner/Schemca Generation:
[img]http://dl.iteye.com/upload/attachment/0068/3490/2f5b929e-0382-3ab0-9e98-7c9e11523333.png[/img]
3.在弹出框这选择Table,然后选择右侧的Partitions 。
点击下面的Preview按钮,能预览建表sql;
也可以点击Generate直接在oracle数据库这建表,第一次点击时会弹出连接数据库的界面,使用用户名密码登陆,数据库的连接名称,添文件tnsnames.ora中配置的名称,如下配置则填写LOCALHOST :
[img]http://dl.iteye.com/upload/attachment/0068/3488/2d72b784-6c9a-3d95-8658-b51aeb56af25.png[/img]
2.选择Tools -> Forward Enginner/Schemca Generation:
[img]http://dl.iteye.com/upload/attachment/0068/3490/2f5b929e-0382-3ab0-9e98-7c9e11523333.png[/img]
3.在弹出框这选择Table,然后选择右侧的Partitions 。
点击下面的Preview按钮,能预览建表sql;
也可以点击Generate直接在oracle数据库这建表,第一次点击时会弹出连接数据库的界面,使用用户名密码登陆,数据库的连接名称,添文件tnsnames.ora中配置的名称,如下配置则填写LOCALHOST :
LOCALHOST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)