Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding Another Datafile

Status
Not open for further replies.
DanAuber

DanAuber

IS-IT--Management
Joined
Apr 28, 2000
Messages
255
Location
FR
can someone remind me of the syntax to do this please as I have long forgotten<br><br>thanks <p>Dan Auber<br><a href=mailto:DanAuber@aol.com>DanAuber@aol.com</a><br><a href= Auber's Home Page</a><br>
 
Sort by date Sort by votes
ALTER TABLESPACE &quot;TBLSPCE_NAME&quot; ADD DATAFILE 'D:\DATABASE\MY_DATFILE2.ORA' SIZE 100M;
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

J
  • Locked
  • Question Question
Oracle Simphony - Adding tip out percentages to Employee Tip Report
Replies
0
Views
591
jj10438
J
hmckillop
  • Locked
  • Question Question
Exporting specific data from DB into another DB
Replies
1
Views
325
Beilstwh
Beilstwh
LarrySteele
  • Locked
  • Question Question
SQLLDR adding a century to pre-1950 dates
Replies
7
Views
867
Beilstwh
Beilstwh
AlStl
  • Locked
  • Question Question
Accessing Objects in another schema under same database
Replies
4
Views
434
Beilstwh
Beilstwh
rk68
  • Locked
  • Question Question
giving user rights to access another schema
Replies
2
Views
338
LKBrwnDBA
LKBrwnDBA

Part and Inventory Search

Sponsor

Back
Top