SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
New user

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
New user
Author Message
lawrence



Joined: 05 Aug 2002
Posts: 1

Post New user Reply with quote

Hi!
I am a new user for Oracle. I found this tools maybe helpful for us.
But I have few problem when using it
1. I am trying to backup the existing whole database by using db zip & it prompt out This column's data type (statistics) requires the use of an embedded SQL statment.
How can I enable the embedded SQL ?

2. When I try to restore the zip file to another machine. it prompt out
Not a valid dbzip archive table catalog not found.
What's the best way to copy the whole database to another machine?

3. Is there any FAQ for those question ?

Thanks for your help ...Sorry I am a fresh guy in Oracle...

Lawrence

Tue Jul 02, 2002 5:57 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Re: New user Reply with quote

: Hi!
: I am a new user for Oracle. I found this tools maybe helpful for us.
: But I have few problem when using it
: 1. I am trying to backup the existing whole database by using db zip & it
: prompt out This column's data type (statistics) requires the use of an
: embedded SQL statment.
: How can I enable the embedded SQL ?

This messages indicates that the table you are trying to zip contains data column with a data type not currently supported by DB Zip such as custom data type, nested table, long raw, etc...

: 2. When I try to restore the zip file to another machine. it prompt out
: Not a valid dbzip archive table catalog not found.
: What's the best way to copy the whole database to another machine?

The zip archive you are trying to use is corrupted. DB Zip is unable to find certain files within the archive that contain catalog and table DDL information.

: 3. Is there any FAQ for those question ?

: Thanks for your help ...Sorry I am a fresh guy in Oracle...

: Lawrence

Mon Aug 05, 2002 9:08 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.