OraFAQ Forum: Server Utilities » structure of table

Home » RDBMS Server » Server Utilities » structure of table

Thu, 02 March 2006 08:49

venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai

Member

i export one table. but i want to import only the structure of the table.data should not be imported.explain with one example

[Updated on: Thu, 02 March 2006 08:50]

Fri, 03 March 2006 00:25

sach_sumit
Messages: 9
Registered: September 2005

Junior Member

Hi

Use

C:\>exp system/solaris file=d:\abc.dmp tables=schema.table_name rows=n

Regards
Sumit Sachdeva

Previous Topic:	exp compatibility with lower verison of Oracle database
Next Topic:	full database export

Goto Forum:

]

Current Time: Thu Dec 26 08:36:02 CST 2024