OraFAQ Forum: Server Administration » Adding additional file to a tablespace

Home » RDBMS Server » Server Administration » Adding additional file to a tablespace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Adding additional file to a tablespace [message #61568]

Wed, 05 May 2004 12:41

Jeff Apple
Messages: 1
Registered: May 2004

Junior Member

Hi All,

how do I add a new datafile to a partition that is nearly filled so that the tablespace can continue to grow in the new datafile. Also I want to stop the autoextend on the old tablespace. This is for Oracle 8.1.7. on Solaris 8.

Thanks

Jeff A.

Report message to a moderator

Re: Adding additional file to a tablespace [message #61572 is a reply to message #61568]

Wed, 05 May 2004 20:41

Anatol Ciolac
Messages: 113
Registered: December 2003

Senior Member

Oracle itself decide where to put new dates. So if you want that old datafile remain without new dates - resize them until the minimum size possible. This step also not very effective because of pctfree/pctused options - Oracle will fill blocks, where percent of dates is smaller than percent of filling a block.

Report message to a moderator

Re: Adding additional file to a tablespace [message #61578 is a reply to message #61572]

Thu, 06 May 2004 07:34

Jeff
Messages: 63
Registered: July 1999

Member

I don't understand your reply. I'm not sure you understand what I am asking here. I have a physical partition that is filling up and need to add another data file to the tablespace.

Report message to a moderator

Re: Adding additional file to a tablespace [message #61587 is a reply to message #61568]

Thu, 06 May 2004 18:37

Trifon Anguelov
Messages: 514
Registered: June 2002

Senior Member

Here's an example:

ALTER TABLESPACE tbs
ADD DATAFILE 'c:temptbs_DATA02.DBF'
SIZE 50K
AUTOEXTEND ON
NEXT 10K
MAXSIZE 100K;

ALTER TABLESPACE tbs DATAFILE '......' AUTOEXTEND OFF;

Hope that helps,

Trifon Anguelov

DBAclick.com | DBA Forums

Report message to a moderator

Re: Adding additional file to a tablespace [message #61591 is a reply to message #61578]

Thu, 06 May 2004 20:53

Anatol Ciolac
Messages: 113
Registered: December 2003

Senior Member

For adding a datafile to tablespace exist very simply and standart script:
ALTER TABLESPACE AUDIT_DATA ADD DATAFILE 'file_name' size 20M
See a full description of command alter in Oracle documentation. This is not a problem for putting them in forum.

Report message to a moderator

Previous Topic:	Database Creation - DBCA bug!
Next Topic:	define Resticted Session

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:27:21 CDT 2024