| creating a test schema [message #142940] |
Tue, 18 October 2005 08:08  |
Zakkhalid
Messages: 47
Registered: April 2005
|
Member |
|
|
I want to create copy of a user, but I don't want to create the objects the same size. How best can I achive this?
So table Z owned by zak which has INITIAL 10649600, I want to recreate table Z, but I want it to be owned by fred but intial 500K ...
Thanks,
|
|
|
|
| Re: creating a test schema [message #142950 is a reply to message #142940] |
Tue, 18 October 2005 08:20  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
1. extract the DDL.
Recreate the object in other schema with your storage.
2. Import only the data
or
insert into user2.table1 (select * from user1.table1)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
