Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

General Questions


How to convert bigfile tablespace to smallfile tablespace


Hi,  How would I convert bigfile tablespace to smallfile tablespace on 10.2.0.4 on unix?  Thank you in advance.

1) Create a new tablespace 2) Move all the object from BIG to normal tablespace  Asif Momen http://momendba.blogspot.com

Hello,  The option BIGFILE cannot be altered to SMALLFILE. So you should create a new Tablespace.  Before moving your datas, be ensure that you have enough capacity in this new Tablespace. So  plan to get enough place on your server.  After moving the content of the Tablespace (it can be done for instance by DataPump)  you could DROP the BIGFILE Tablespace and RENAME the new SMALLFILE Tablespace   so as to keep the original name, as follow: CREATE SMALLFILE TABLESPACE <NEW_TBS_NAME>;   --> Move or export/import the content   DROP TABLESPACE <ORIGINAL_TBS_NAME> INCLUDING CONTENTS AND DATAFILES;    ALTER TABLESPACE <NEW_TBS_NAME> RENAME TO <ORIGINAL_TBS_NAME>;   Hope this help. Best regards, Jean-Valentin  Edited by: Lubiez Jean-Valentin on Feb 24, 2010 7:39 PM

In addition to the answers - you cannot simply convert the tablespace - why do you want to do that. What is so bad with your bigfile tablespace?  Kind regards Uwe  http://uhesse.wordpress.com


Related Links

DBCA hangs on database delete for RH 2.1 advanced server
RAC Performance problem
Performance Manager on 8.1.7.3 database?
change table's tablespace
importing CLOB datatype
Update Clause (can These Queries be more tunned)
FORMS_MDI_ICON CHANGE
Download Oracle 8.0
ORA-12560 in database restore cold backup
no listener
problem with export : invalid column name
ORA-01536: Tablespace Quota Error...
Temp Tablespace filled up!!?!
Database monitoring sql's
How to recover windows database
Oracle FailSafe Questions