• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1072
  • Last Modified:

reuse existing command when adding a datafile

I am running oracle 10g on windows server 2003.  When you are adding a new datafile, what does the command "reuse existing" do?  
0
PsychoDazey
Asked:
PsychoDazey
  • 2
  • 2
1 Solution
 
mohammadzahidCommented:
Reuse command link an exisiting datafile on a file system that is not linked to any tablespace in the database to a tablespace.
0
 
PsychoDazeyAuthor Commented:
Im not sure I follow...what would the command:
ALTER TABLESPACE users
    ADD DATAFILE '/u02/oracle/rbdb1/users03.dbf' SIZE 10M reuse existing
do?
0
 
mohammadzahidCommented:
Here is a site that can help you with an example and explanation.

http://www.psoug.org/reference/datafiles.html
0
 
PsychoDazeyAuthor Commented:
I see...so basically I would have to first drop that file then add it using the reuse command?  Thanks for your help again.
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now