Home » RDBMS Server » Server Utilities » creating a table space....in 8i or 8.....?
creating a table space....in 8i or 8.....? [message #72579] Wed, 23 July 2003 10:22 Go to next message
shahzad-ul-hasan
Messages: 615
Registered: August 2002
Senior Member
dear sir,
pls help me. i have an urgent help required from you. my oracle tablspace of system is full now. now i want to create a new tablespace in my sysor1.dbf (datafile). pls help me or give me script to create a new tablespace......
thanks for help......

q.nO 2

i want to get a backup by rman. and my backup type is online . so i can required the backup by rman and by script....
thanks for help

Report message to a moderator

Re: creating a table space....in 8i or 8.....? [message #72580 is a reply to message #72579] Wed, 23 July 2003 11:47 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
add a datafile for the system tablespace

alter tablespace system add datfile 'COMPLEte_PATH_FOR_NEWFILE' size < size_of_file > M;

Report message to a moderator

Previous Topic: Updation of Oracle database to another system??
Next Topic: Why did fromuser touser not work
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 13:45:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.