1. Create or use two existing tablespaces on the source database. Although having two tablespaces is not necessary, it was merely shown here to exercise object dependency. Note that OMF is being employed in this illustration, thus please set the init.ora parameter DB_CREATE_FILE_DEST to the ...
2.绑定ASM磁盘 [root@danaly data1]# /etc/init.d/oracleasm createdisk VOL5 /dev/cciss/c0d0p10 Marking disk "/dev/cciss/c0d0p10" as an ASM disk: [ OK ] [root@danaly data1]# /etc/init.d/oracleasm createdisk VOL6 /dev/cciss/c0d0p11 Marking disk "/dev/cciss/c0d0p11" as an A...
62.51 GB You can use alter tablespace command to extend tablespace in Oracle: SQL> alter tablespace RAIDDATA add datafile 'FILE_LOCATION' size 100m autoextend on maxsize 31G; Note: You can find file location from the 1st query as mentioned above. In case of ASM, use diskgroup name as a...
Drop the original temp tablespace. Drop temp tablespace DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES; If you want to change the name from TEMP1 to TEMP, then follow the same process as below. Create TEMP tablespace CREATE TEMPORARY TABLESPACE TEMP TEMPFILE /u01/app/temp/temp01′ SIZE ...
In this post, I will explain one of my last works about the ASM disk header block. First, I will create a TEST tablespace in my orcl database. The TEST’s datafile will be managed by ASM. [oracle@oel ~]$ . oraenv ORACLE_SID = [+ASM] ? orcl ...
If You are using ASM then use diskgroup name. SQL> show parameter db_create_file_dest SQL> create temporary tablespace temp1 tempfile '+DATA1' size 10G; STEP 3: Make new tablespace to the default temp tablespace SQL> alter database default temporary tablespace temp1; ...
To collect the list of files in ASM with their full path, use the Note 888943.1 named "How to collect the full path name of the files in ASM diskgroups" There are two ways to perform this: 1. Create a new Diskgroup with desired redundancy and move the existing data...
Which storage system is this statement describing: A high-end, disk storage system with a virtualized grid architecture designed to eliminate the complexity of storage administration and make managing...
( The step 5 to step 8 is based on the filenames from method b). 4.a).Using DBMS_FILE_TRANSFER package SQL:ORCL>create or replace directory orcl1 as '+asmdsk1/orcl/datafile'; SQL:ASM> Alter disgroup asmdsk2 add directory '+asmdsk2/test'; ...
CREATE TABLESPACEwide_tab DATAFILE '/u01/oracle/db/AKI1/tab/wide_tab.dbf' SIZE50MREUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K SEGMENT SPACE MANAGEMENT AUTO BLOCKSIZE16K PERMANENT ONLINE; Check Sizes in Oracle Enterprise Manager You can see, the manually configured16K buffer cacheand all other ...