![]() On the Specify Objects page, click Lookup, then double-click the REGIONS table on the left to have it appear in a row in the bottom part of the page. On the Types to Export page, deselect Toggle All, then select only Tables (because you only want to export data for a table). ![]() (In the figure, this file is C:\temp\export.xls.) Save As location: Enter or browse to a desired folder on your local hard drive, and specify the file name for the. sql script file is generated (which will not happen in this example), it will not contain any CREATE statements, but only INSERT statements.įormat: Select xls to have the data saved to a Microsoft Excel. Optionally, click the REGIONS table in the Connections navigator, and examine the information under the Columns and Data tabs in the main display area.įigure 10-3 Export Wizard: Source/Destination Specifying Data Export Onlyĭescription of "Figure 10-3 Export Wizard: Source/Destination Specifying Data Export Only"Īccept the default values for the Source/Destination page options, except as follows:Įxport DDL: Deselect (uncheck) this option. In the Connections navigator, expand the Tables node under the NICK connection. ![]() The Script Output pane shows that the REGIONS table has been created and four rows have been inserted. In the SQL Worksheet for the NICK connection, type the the Run Script icon. If you have not already created a database connection for NICK, create the connection. To re-create the REGIONS table in the schema of user NICK by invoking the script in C:\temp\export.sql follow these steps using SQL Developer: ![]() This other schema can be an existing one or one that you create.įor example, assume that you created a user named NICK following the instructions in "Example: Creating a User". Example: Importing Metadata and Data Using a Script FileĪssume that you wanted to re-create the REGIONS table that you exported in "Example: Exporting Metadata and Data for a Table", but in a different schema. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |