Tag Info

New answers tagged

2

While copying a tablespace, it automatically includes data files and indexes associated with it. You need to make sure that tablespace is self contained. Confirm that tablespace is self contained execute DBMS_TTS.TRANSPORT_SET_CHECK('<TABLESPACENAME>', true); Use the TRANSPORT_SET_VIOLATIONS view to check if any violations condition exists select * ...


0

Are you using Oracle 7? If not, please make sure to always use current versions of documentation. Oracle is already on 12C, and while some concepts still the same, a huge part of features has changed. You actually won't get column size. This is why it is only an "estimate". You need to have an idea of what you are going to need, and then you can use the ...


1

This error code [ORA-01654] means the server has failed to allocate an extent of the required number of blocks for an index segment in the specified tablespace. As you have said you have got 13 datafiles in your tablespace, you are using small file tablespace. In order to get rid of this error you can simply add data file using ALTER TABLESPACE ADD DATAFILE ...


0

Oracle specifically split out the sysaux from the system, and IMO this was a good choice by them. Essentially, without going deeply into the documentation which you can read for yourself, SYSAUX stores things like statistics history, non-essential performance views, and other pieces of metadata that may or may not be in-use in a particular database, ...


1

First, it is important to understand the purpose of SYSAUX tablespace. As the name implies, it is intended to support system tablespace, by holding metadata about database components and other frequent changing data, such as reports. Docs: "If the SYSAUX tablespace becomes unavailable, core database functionality will remain operational. The database ...



Top 50 recent answers are included