How to export the table structure of an Oracle database?

You can use Oracle’s export tool expdp to export database table structure, the specific steps are as follows:

1. Open the command prompt window and enter the following command to log in as the sys user in the Oracle database:
2. Log in to SQLPlus as the system administrator.
3. Set up a directory for storing exported table structure files, for example:
4. Establish a directory named export_dir at ‘C:\export’.
5. Log out of the sys user, and log in to the Oracle database as a regular user.
6. Export table structure using the expdp command, for example:
7. Export metadata only from the tables using the expdp utility with the specified username and password, export directory, and dump file name.
8. The username and password refer to the credentials of the database user, export_dir is the directory created previously, tables.dmp is the name of the exported table structure file, and CONTENT=METADATA_ONLY indicates that only metadata will be exported without any data.
9. After the export is completed, the generated tables.dmp file, containing the definition information of the database tables, can be found in the export_dir directory.

Please note that the above steps use the expdp command, which is available in Oracle 10g and above. If you are using Oracle 9i or earlier versions, you can use the exp command to export the table structure.