Home » SQL & PL/SQL » SQL & PL/SQL » Truncate the full database (Oracle 9i, HP-UX)
icon4.gif  Truncate the full database [message #347968] Mon, 15 September 2008 03:58 Go to next message
sanei05
Messages: 103
Registered: September 2008
Senior Member
hi,

Can anyone help me whether can we truncate the full database.

Pls. urgent............
Re: Truncate the full database [message #347970 is a reply to message #347968] Mon, 15 September 2008 04:04 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
No, you can't.

You can Truncate tables.
You can Drop Users,
In 10g, you can Drop the database

But there is no Truncate option for databases.
Re: Truncate the full database [message #347974 is a reply to message #347970] Mon, 15 September 2008 04:11 Go to previous message
sanei05
Messages: 103
Registered: September 2008
Senior Member
Thanks...

EDITED by LF: removed the multi-master replication question from this message, as
a) it doesn't belong here
b) @sanei05 has already opened a new topic in the Replication forum regarding this new problem.

[Updated on: Mon, 15 September 2008 05:07] by Moderator

Report message to a moderator

Previous Topic: Check uniqueness of data.
Next Topic: Error while opening cursor when using TRANSLATE
Goto Forum:
  


Current Time: Thu Dec 08 14:50:14 CST 2016

Total time taken to generate the page: 0.21874 seconds