Use dbexportdoc V1.0 for Oracle to export the database table structure

Use dbexportdoc V1.0 for Oracle to export the database table structure

 

Only download the tool and some basic usage steps are found on the Internet, but the specific usage of the tool is not described, the following describes how to use it based on my usage experience.

 

If the office version is 2003, The enable macro dialog box is displayed when dbexportdoc V1.0 for oracle.doc is opened. Select Yes. If a macro is disabled for word, you need to enable the macro first, choose "Tools"> "macro"> "security"> set the macro security level to <medium> or <none>, we recommend that you set it to <medium> level.

If the office version is later than 2007, you need to open dbexportdoc V1.0 for oracle.doc, click the position in the upper left corner (under the menu item)"Security WarningThe macro has been disabled. Option "here, click the Option Button, select enable this content, and then confirm. Or click the menu in the top menu bar of the Office, and the hidden black downward arrow on the right, choose "Other commands"> "trust center"> "trust center Settings"> "enable all macros". Note that this method is not recommended, we recommend that you use dbexportdoc V1.0 for oracle.doc to export the database table structure and set the macro to disabled !!!

 

After dbexportdoc V1.0 for oracle.doc is successfully opened, a database connection dialog box is displayed. If the dialog box is accidentally closed or does not pop up, you can close dbexportdoc V1.0 for oracle.doc and try again. If it still doesn't work, select the "add-on" menu of word. Then you can see a drop-down menu such as dbexportdoc in the upper-left corner. Click the drop-down button, then select "connect database" to see the interface for connecting to the database.

Select the second connection item (in fact, there is little difference between the two items. The first is to connect to the local database, and the second is to connect to a remote database. Of course, you only need to write the data source correctly)

Provider = msdaora.1; Password = test; user id = test; Data Source = Local; persist Security info = true

Provider = msdaora.1; Password = test; user id = test; Data Source = ydgl126; persist Security info = true
The main configuration items are as follows:

User ID: username used to log on to the database

Password used to log on to the database

SERVICE_NAME of the data source database

Both user ID and password are well solved. These two are the most basic. The key is Data Source. If you need to connect to a remote database, I also configured the service instance name at the beginning, and the result is still a real connection error. A large error red warning box is displayed. For example, if the IP address of the database server is 192.168.1.102, the port is 1521 by default, and the service instance name is orcl. For example, if the username and password of the database connection are both testoracle, then provider = msdaora.1; Password = test; user id = test; Data Source = ydgl126; persist Security info = true can be modified

Provider = msdaora.1; Password = testoracle; user id = testoracle; Data Source = 192.168.1.102: 1521/orcl; persist Security info = true

If the port is the default 1521 port, it can be omitted to 192.168.1.102/orcl. If it is not the default port, You need to specify the port.

What if I don't know the database service instance name?

1. Find the tnsname. ora file and check whether the configured connection to the database 192.168.1.102 has SERVICE_NAME.

2. If the tnsname. ora file contains only Sid and does not have SERVICE_NAME, you can use PL/SQL to connect to the database server and create a new command window,

Run the show parameter service_names; command to obtain the SERVICE_NAME. You can also use the query analyzer for execution.

 

After the database is connected successfully, the export table window is displayed. If the data export window is not displayed, select the "add-on" menu of word, and a drop-down menu such as dbexportdoc is displayed in the upper-left corner, click the drop-down button, select "Export Database Table Structure", select the user to export data, and then select the table to export (you can press Ctrl or shift to select multiple ), click "-->" to add it to the view box on the right, and then click Export.

 

If you still cannot connect according to the above steps, you need to select a specific database adaptation method.

You can select "new connection..." in the database connection window... ", and then select the correct driver. We use ORACLE as the example" Microsoft ole db provider for Oracle ", click Next, and enter 192.168.1.102: 1521/orcl in the input server name, then, enter the user name and password (if it is the default port, You can omit it), and click test connection to test whether the connection is successful.

Make sure that the SERVICE_NAME and port of the database are correct during connection.

 

Dbexportdoc V1.0 for oracle.doc reference address:

Http://wenku.baidu.com/view/0bb6624de518964bcf847c51.html

Dbexportdoc V1.0 for oracle.doc download link:

Http://www.itpub.net/thread-1003383-1-1.html

Http://devbbs.doit.com.cn/thread-1132-1-1.html

Http://download.csdn.net/source/3384395