In a UNIX, type the command line: sqlplus user_name/ password filename If you do not specify a table, the script takes all tables for the user and copies them to separate files. User ID and password are your user ID and password for the appropriate component Where are options that apply to reinserting the data as follows: In a UNIX operating system, type the command line: ora_dump_sql user ID/ password If there is more than one table, the script creates a separate file for each one. sql, where TABLE NAME is the name of the table in uppercase characters. The ora_dump_sql script copies the table data to a file named TABLE NAME. All the static data tables are listed by component following these procedures. If the data used for the static tables is already stored within flat files, then simply load the data into the tables. If you want to move your static data from one database to another, you must first save the data in a flat file and then load the data into the new database.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |