我这里没有电子资料,写一下吧 copy from username/password@dbname to username1/pw1@dbname1 append(create/insert/replace) tablename(col1,col2...) using select....from ...; append:添加到表上,如果tablename表不存在,则建立此表 create:如果tablename表存在,则出错 insert:添加到表中,如果tablename表不存在,则出错 replace:替换表中数据,如果tablename表不存在,则建立此表.
To bzszp(SongZip):我是这样用的: set Copycommit 1 Set arraySize 100 Copy from username/password@dbname- to username1/pw1@dbname1- append dbname- Using Select * from dbname1在sql/plus里前几次执行时报错:ORA-01458: 内部变量字符串长度非法。在多执行几次,就成功拉!这是怎么回事???
不好意思,刚才用错用户名了!To bzszp(SongZip):我是这样用的: set Copycommit 1 Set arraySize 100 Copy from username/password@dbname- to username1/pw1@dbname1- append dbname- Using Select * from dbname1在sql/plus里前几次执行时报错:ORA-01458: 内部变量字符串长度非法。在多执行几次,就成功拉!这是怎么回事???
刚才写错了:Sorry!我是这样用的:set Copycommit 1 Set arraySize 100 Copy from username/password@dbname- to username1/pw1@dbname1- append Tablename- Using Select * from Tablename1在sql/plus里前几次执行时报错:ORA-01458: 内部变量字符串长度非法。在多执行几次,就成功拉!这是怎么回事???
maybe:ORA-01458 invalid length inside variable character string Cause An attempt was made to bind or define a variable character string with a buffer length less than the two-byte minimum requirement. Action Increase the buffer size or use a different type.
如何在Delphi下调用SqlPlus copy命令?
2)在Delphi中用ShellExecute执行该脚本,参数为sqlplus internal/oracle@server @c:\a.sql
或者写成unix的shell脚本,不过好像delphi调用不了
为什么一定要用copy命令,这是sqlplus专用的???
结合这种情况,那位高手有更好的解决方法,请赐教。
moveingBoy的方法应该可以!
谢谢!
[email protected]
copy from username/password@dbname
to username1/pw1@dbname1
append(create/insert/replace) tablename(col1,col2...)
using select....from ...;
append:添加到表上,如果tablename表不存在,则建立此表
create:如果tablename表存在,则出错
insert:添加到表中,如果tablename表不存在,则出错
replace:替换表中数据,如果tablename表不存在,则建立此表.
set Copycommit 1
Set arraySize 100
Copy from username/password@dbname-
to username1/pw1@dbname1-
append dbname-
Using Select * from dbname1在sql/plus里前几次执行时报错:ORA-01458: 内部变量字符串长度非法。在多执行几次,就成功拉!这是怎么回事???
set Copycommit 1
Set arraySize 100
Copy from username/password@dbname-
to username1/pw1@dbname1-
append dbname-
Using Select * from dbname1在sql/plus里前几次执行时报错:ORA-01458: 内部变量字符串长度非法。在多执行几次,就成功拉!这是怎么回事???
Set arraySize 100
Copy from username/password@dbname-
to username1/pw1@dbname1-
append Tablename-
Using Select * from Tablename1在sql/plus里前几次执行时报错:ORA-01458: 内部变量字符串长度非法。在多执行几次,就成功拉!这是怎么回事???
Action Increase the buffer size or use a different type.
改完后
重新启动数据库
max_enabled_roles = 30
db_file_multiblock_read_count = 8db_block_buffers = 8192shared_pool_size = 62428800large_pool_size = 914400
java_pool_size = 30971520log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800processes = 1015parallel_max_servers = 5log_buffer = 32768