I have created a tablespace with pagesize of 4k.It contains one table which is populated.Each record of this table has a size of more than 3k and less than 4k.So each page contains only one record.
Now i want to shift that data to new table in a new tablespace whose pagesize is 8k.How will it store the records now.Will it put the contents of two pages into one single page in the new tablespace.If not then i might lose hard disk space.So what should be done...