怎样让oracle表空间缩小(国外英语资料).docVIP

怎样让oracle表空间缩小(国外英语资料) How do you get the Oracle table space to shrink the noil? [question number: 40 points, the post: yo_yo2005] yo_yo2005 Rating: Post rate: 97.87% The building was published in: 2011-02-18 14:24:18 A few years of oracle database, the tablespace has been expanded a lot I delete all the data from the database 90% of the Table (with Truncate Table XXX;) Then export a DMP file Although this DMP file is only 20M I rebuild my table space on a new computer (the tablespace file is only 50 megabytes) Then import this DMP file into this database (the tables have basically no data) But the tablespace file becomes 4G, and it doesnt shrink The expert asked how to reduce the tablespace file I can use [0] to drop a board brick [0] to report management TOP response times: 11 yo_yo2005 Rating: # 1:0:02-1815:44:35 No one can help me I use [0] for me to throw a board brick [0] to report management TOP Best recommendation: the other BBS Oracle edition is a big one, and its hot. Why do you feel that the Oracle version of CSDN is a bit cold??? xman_78tom (escape) Rating: 3 2 # 2 building scores: 3 replies to: 2011-02-18 16:11.13 Alter database datafile filename resize size; I use [0] for me to throw a board brick [0] to report management TOP Essence recommendation: classic SQL statement collection (ORACLE) huojianfashe (frank) Rating: # 3 building scores: 5 replies to: 2011-02-18 19:46:54 Two ways: Remove the table space and rebuild it Minimize the size of the data file Select file_name from dba_data_files where TABLESPACE_NAME = tbs_name; Alter database datafile filename resize size; I use [0] for me to throw a board brick [0] to report management TOP Best recommendation: the oracle interview topic summary - (300 points)! tianlesoftware (Dave) Rating: # 4 building scores: 1 reply: 2011-02-18 23:11:15 Quotes from the 2nd floor xman_78tom: Alter database datafile filename resize size; Agree with you. By the way. These things can be googled. Write down the key words an