Oracle7 Administrator's Reference for UNIX

Contents Index Home Previous Next

Restrictions

COPY Command

The COPY command in SQL*Plus is supported without restrictions on different machines running the same version of the operating system.

COPY may also work between machines running different versions of the operating system. If COPY fails, test the connection using rcp or ftp. Restrictions in vendor-supplied networking software may also prevent rcp or ftp from functioning properly between systems. The same restrictions may cause COPY to fail.

Note: The rlogin command does not send and receive large packets of data and is not an adequate test for connections.

If COPY does not function between systems, create a database link to the system and user ID indicating the table you want to copy. To do this, enter:

SQL> create table newtable as \
(SELECT * FROM table@database_link_name)

This selects the rows and columns from the original table on the remote system and enters them in the new table.

Resizing Windows

The default value for SQL*Plus LINESIZE is 80 and for PAGESIZE is 25. These variables do not automatically adjust for window size.

Return Codes

UNIX return codes require one byte, which is not enough space to return an Oracle error code. The range for a return code is 0 to 255.


Contents Index Home Previous Next