What is tablespace in oracle?
how can we create?
how is it manage?
.
.
.
Thnx 2 All in Advnc....:)
- 3 Answers
- 3824 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramya
The Structure of the table is known as tablespace,
create tablespace
users
datafile
‘/ora01/oracle/oradata/booktst_users_01.dbf’
size
50m;
using alter query we can manage the tablesapace
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is an oracle tablespace?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Explain oracle left join with an example?
What is the usage of synonyms?
How to create a new table in oracle?
What is memory advisor in Oracle?
How can I introduce multiple conditions in like operator?
How to export several tables together?
What is redo log?
How to use subqueries with the in operator using oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
How to change program global area (pga) in oracle?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What is SQL access advisor in Oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
