Home » RDBMS Server » Server Utilities » How to recreate a tablespace
How to recreate a tablespace [message #265535] Thu, 06 September 2007 10:51 Go to next message
manasbis
Messages: 8
Registered: August 2007
Junior Member
Can anybody tell me how to recreate a tablespace after dropping it. And what are the parameters are needed for the same.
Re: How to recreate a tablespace [message #265536 is a reply to message #265535] Thu, 06 September 2007 10:57 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Do you want to perform RECOVERY of dropped tablespace or you want to recreate it.

New Tablespace create syntax

http://www.ss64.com/ora/tablespace_c.html

Restore tablespace

http://www.oracle-base.com/articles/9i/RecoveryManager9i.php
Re: How to recreate a tablespace [message #265544 is a reply to message #265536] Thu, 06 September 2007 11:16 Go to previous messageGo to next message
manasbis
Messages: 8
Registered: August 2007
Junior Member
No, I want to recreate it after dropping in oracle8i. Actually one of the datafiles is in recover state and the required archive log is missing, so I want to recreate the tablespace after dropping the same. Then I will import back the data. Please tell me the entire procedure if possible.
Re: How to recreate a tablespace [message #265548 is a reply to message #265544] Thu, 06 September 2007 11:26 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
So you want the same Structure as it was before dropping??

If you have full Export Dump? then grep the dump

like this

$  grep 'CREATE TABLESPACE "SYSAUX"' full_export.dmp
CREATE TABLESPACE "SYSAUX" BLOCKSIZE 8192 DATAFILE  '/u305/oradata/qlink/QLINK_SYSAUX.DBF'
 SIZE 1048576000 REUSE EXTENT MANAGEMENT LOCAL 
 AUTOALLOCATE  ONLINE PERMANENT  SEGMENT SPACE MANAGEMENT AUTO
$


[Updated on: Thu, 06 September 2007 11:26]

Report message to a moderator

Re: How to recreate a tablespace [message #265927 is a reply to message #265535] Sat, 08 September 2007 00:20 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Just create tablespace with datafile. Don't worry about other parameter.
Previous Topic: Import Utility Hang
Next Topic: Entry/Exit code is optimized. cannot restore context (UNWIND 22)
Goto Forum:
  


Current Time: Sat Dec 10 11:00:51 CST 2016

Total time taken to generate the page: 0.09567 seconds