answersLogoWhite

0

How do you rellocate a datafile?

Updated: 12/20/2022
User Avatar

Wiki User

11y ago

Best Answer

Alter tablespace is the command

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you rellocate a datafile?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the difference between database file and datafile?

Datafile is a group of files in each table space in an Oracle database. Database files are all files that are found within the database.


What is the industry average for Capital Expenditure?

http://people.stern.nyu.edu/adamodar/New_Home_Page/datafile/capex.html


What has the author Neil Webster written?

Neil Webster has written: 'DMU Datafile' 'European Locomotive Pocket Book' 'DMU and Light Rail Datafile' 'Locomotive Hauled Travel' 'European Loco Pocket Book' 'EMU Datafile' 'European Railways' 'Panchayati raj and the decentralisation of development planning in West Bengal' -- subject(s): Panchayat, Local government


You are given a text file named datatxt The file contains a list of integer scores The number of scores is unknown You are required to write a C program to read ALL the scores from the?

#include #include #include using std::cin;using std::cout;using std::endl;using std::ifstream;//function prototypesint numberOfElements(ifstream& inData);void readDataFromFile(ifstream& inData, long* dataFile, int arraySize);int main(){const char fileName[] = "data.txt";ifstream inData;inData.open(fileName, std::ios::in);if (inData.fail()){cout


Is pastor donnie mcclurkin fiance from the US?

No,she lives in a different continent.She'll rellocate to the US after their private wedding.Then people will know who she is................an anointed,beautiful woman of God.


How to make a Datafile auto extendible?

Yes,use EXTENT MANAGEMENT LOCAL AUTOALLOCATE while creating tablespace.


What oracle will do in datafile media recovery?

first of all ur database in mount mode.... and then enable archieve log and then check


How can you cancel your datafilecom account?

You can cancel your Datafile account by going into the settings and choosing to cancel. If you are still having a problem you can click the Contact Us link at the bottom of the page.


What is a Checkpoint in oracle?

A checkpoint performs the following three operations:Every dirty block in the buffer cache is written to the data files. That is, it synchronizes the datablocks in the buffer cache with the datafiles on disk. It's the DBWR that writes all modified databaseblocks back to the datafiles.The latest SCN is written (updated) into the datafile header.The latest SCN is also written to the controlfiles.The update of the datafile headers and the control files is done by the LGWR(CKPT if CKPT is enabled). As of version 8.0, CKPT is enabled by default.


What is the Financial Leverage Ratio Industry Average for Manufacturing?

Go to:http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/Betas.htmlSaludos, EduardoA.You can visit www.Fintel.us for financial ratios from over 2,500 industry groups covering 900,000 privately held companies.


How do you get expansion packs to work for fallout 3?

If your asking about the the PC verion. Launch fallout 3 then at the beginning where you normally click 'Play', there are options and one says 'datafile'. Click that and make sure the expansion packs are ticked.Pointlook out should be available straight away. Broken steel you need to complete the main quest of the 'standard' game.


What is sql loader?

SQL LOADER is an Oracle utility used to load data into table given a datafile which has the records that need to be loaded. SQL*Loader takes data file, as well as a control file, to insert data into the table. When a Control file is executed, it can create Three (3) files called a log file, bad file or reject file, discard file. * Log file tells you the state of the tables and indexes and the number of logical records already read from the input datafile. This information can be used to resume the load where it left off. * Bad file or reject file gives you the records that were rejected because of formatting errors or because they caused Oracle errors. * Discard filespecifies the records that do not meet any of the loading criteria like when any of the WHEN clauses specified in the control file. These records differ from rejected records.