Sony 1. You can expand a datafile if it is full, assuming your storage device still has space and you are not near your operating system limit. 2. You can move a datafile to another storage device if you need to. 3. If you need to move data out of a datafile, the easiest way to do this is to create a second tablespace, which will have its own datafile(s). Then move the objects stored in the first tablespace into the second tablespace. 4. Within a tablespace that has more than one datafile, you can't tell Oracle where to put the data, or to move data from one datafile to another. I hope one of the above responds to your question. :-)
Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Tuesday, February 18, 2003 1:24 AM To: Multiple recipients of list ORACLE-L Dear Listers, Would someone on this list help me to solve these problems, 1. I've three datafiles x1 and x2 2. If datafile x1 is full, I want it is automaticaly move to datafile x2 including all data in datafile x1. 3. If it is possible how to do it. Many thanks for respons and all comments would be appreciated. Kind rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
