今天终于在一家英文网站上找了答案 说是一个BUG,手工建吧!
Caveats
Some of the issues that I encountered are reported to
have been corrected in Oracle10g, although I haven’t yet
experimented with the DBCA in 10g to verify the fixes.
After the cloning process completes, it may be
necessary to UNLOCK and RESET users’ passwords.
You can use OEM to verify and unlock any users.
Also, the listener and TNSNAMES file must be
configured via the Net Configuration Assistant.
During an initial attempt at creating a template, I
received the following
error: Invalid Entry Size (expected
3130007552 but got –1164959744 bytes).
The process
stopped at the UNDOTBS01 file creation, which was
created on the development platform with a size of
2.91GB.
After checking with Oracle, it turned out to be a bug
(2536772) in 9.2. On MetaLink, note 209516.1 lists a
workaround, which is to reduce the datafile size to less
than 2GB if possible.
According to reports, the bug has been fixed in 10g.
It’s not possible to fix this issue in 9i DBCA because of
Java’s limitation with respect to its Zip classes.
As an option, if you’re considering using the
template feature to clone databases, you may want to
create your primary database with multiple .dbf files
for tablespaces under the 2GB size, prior to building
any templates.
And finally, I encountered another small problem
with DBCA. When using DBCA to create a template
from a running DB, the database is locked. After the
template creation process is completed, the DB remains
locked. There’s no notification given prior to or after
the process completes. According to Oracle, this appears
to be expected behavior. A bug was filed on this, and
development engineers said that it was expected behavior
and wouldn’t be fixed. However, they did suggest that at
some point they might put in a confirmation message
before the shutdown of the database occurs. So, the only
change in the behavior expected to be added is that there
will be a message to let the user know that the database
will be shut down.