Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Performing hot backup with JDBC in Java

Status
Not open for further replies.
bhunter

bhunter

Programmer
Jul 27, 2000
36
US
I am working on an application in Java, and I have written some code using a JDBC connection and prepared statements to send SQL commands. I can put a tablespace into the begin backup mode with "ALTER TABLESPACE SYSTEM BEGIN BACKUP" inside of the prepared statement in Java. However, when I issue the command "host copy e:\oracle...\system01.dbf c:\backup" inside of a prepared statement I get an error saying it is not a valid SQL command. This copy command works fine inside of SQLPlus. I'm sure that there is a way to do it with JDBC. I want to send a command to the DB server to copy the tablespace file. Can anyone who has done this with Java before help me out?

Thanks,

Bennett
 
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
353
carp
carp
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
362
SkipVought
S
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
432
Andrzejek
Andrzejek
TheLazyPig
  • Locked
  • Question
Change format name with comma 1
Replies
3
Views
116
TheLazyPig
TheLazyPig
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
178
carp
carp

Part and Inventory Search

Sponsor

Back
Top