REPOST: Adding Datafiles

From: Jennmar Corp <here_at_work.com>
Date: Mon, 31 Dec 2001 08:08:11 -0500
Message-ID: <8$--$$-$-__$---_%$@news.noc.cabal.int>

Hello -
I have a question regarding adding datafiles to a tablespace. We are running out of space for a certain tablespace and need to add an additional datafile.

We were simply going to use the Create Like command and copy the original settings of the initial datafile.

The option to "Reuse existing Datafile" is checked on the only datafile for this tablespace. Should this be checked on the one we are adding and any subsequent datafiles? How/What does this setting affect?

Thanks!

WAS CANCELLED BY =======: Path: news.sol.net!spool1-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!newsfeed.direct.ca!look.ca!newsfeed1.earthlink.net!newsfeed.earthlink.net!uunet!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r From: "Jennmar Corp" <here_at_work.com> Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.misc Subject: cmsg cancel <u30op8b7lhrpbd_at_corp.supernews.com> Control: cancel <u30op8b7lhrpbd_at_corp.supernews.com> Date: Wed, 2 Jan 2002 00:36:43 GMT Organization: The World's Usenet -- http://www.Supernews.com Lines: 2 Message-ID: <cancel.u30op8b7lhrpbd_at_corp.supernews.com> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009943435 19888 166.102.15.34 (2 Jan 2002 03:50:35 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 2 Jan 2002 03:50:35 GMT X-No-Archive: yes Comment: Dude, where's my NewsAgent?

autocancel Received on Mon Dec 31 2001 - 07:08:11 CST