|
|
|
|
| Re: How to recreate a tablespace [message #265544 is a reply to message #265536] |
Thu, 06 September 2007 11:16   |
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 |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
