| Space check [message #268103] |
Mon, 17 September 2007 09:17  |
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
|
Senior Member |
|
|
hi guys,
can anybody tell me why do we check space on default tablespace while doing logical backup (import/export).
another is why do we specify default tablespace during user creation.
Cheers
Balaji
|
|
|
|
| Re: Space check [message #268186 is a reply to message #268103] |
Mon, 17 September 2007 22:24  |
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
|
Senior Member |
|
|
| balaji1482 wrote on Mon, 17 September 2007 09:17 |
another is why do we specify default tablespace during user creation.
|
If you do not specify default tablespace then its assign to system tablespace. And it is suggested that specify specific tablespace for each schema. That why we specific default tablespace during user creation.
|
|
|
|
| Re: Space check [message #268194 is a reply to message #268103] |
Mon, 17 September 2007 23:13 |
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
|
Senior Member |
|
|
| Quote: | another is why do we specify default tablespace during user creation.
If you do not specify default tablespace then its assign to system tablespace.
|
This is not true. It's depend on database creation script. When you use DBCA default tablespace is users.
[Updated on: Mon, 17 September 2007 23:27] Report message to a moderator |
|
|
|
| Re: Space check [message #268196 is a reply to message #268103] |
Mon, 17 September 2007 23:23 |
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
|
Senior Member |
|
|
| Quote: | why do we check space on default tablespace while doing logical backup
|
We should check space because data will imported into default tablespace if you don't specify.
If default tablespace is not assigned data goes to system tablespace.
[Updated on: Mon, 17 September 2007 23:29] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
