Jump to content

reem-akk

Members
  • Content count

    13
  • Joined

  • Last visited

Community Reputation

0 Neutral

About reem-akk

  • Rank
    Member
  1. thanks very much I agree your answer but I have been meaning ,what is the bigger size in complete database?? is it 4G in oracle 10g??? as you told me that It is a bad idea to use quotas but quotas idea is present so when should we use?
  2. I am so much obliged my sir..... burleson I read your great tips about recyclebin and I made a sole expirement as you told me to do, I do these steps: create table create view from prevuios table drop view show recyclebin ,nothing in it so I concluded that no way to get back alone view, you can flashback table and its views related it but you can't flashback only view because there is some objects don't get away to recyclebin when we drop as like as view , I have got confirmation of it when we do query: show recyclebin there is nothing I have enjoyed this discussion , thank you
  3. I am so much obliged my sir..... Boobal Ganesan I do these steps: create table create view from prevuios table drop view show recyclebin ,nothing in it so I concluded as you told me that no way to get back aand lone view, you can flashback table and its views related it but you can't flashback only view because there is some objects don't get away to recyclebin when we drop as like as view I have enjoyed this discussion , thank you but i could'nt understand all displayed objects as like LOB partition, IOT OVERFLOW SEGMENT IOT MAPPING TABLE , can you help me where I find it in a simple manner to understand???
  4. I am so much obliged my sir..... I read your great tips about recyclebin and I made a sole expirement as you told me to do, I do these steps: create table create view from prevuios table drop view show recyclebin ,nothing in it so I concluded that no way to get back alone view, you can flashback table and its views related it but you can't flashback only view because there is some objects don't get away to recyclebin when we drop as like as view , I have got confirmation of it when we do query: show recyclebin there is nothing I have enjoyed this discussion , thank you
  5. hi guys i have very important question : i create user and grant you by(sys administrator) connect role and create table privilige and not resource role so we have to grant it quota on users tablespace, so to what extent we can grant quota for user account??? in other words how size every body can have for his datafiles????
  6. hi guys i want ask this question : if i create view from table ,what happened if the table is dropped? and is there a way to flasback different objects from recycle bin like views and indexes etc..... as similar as table????????
  7. it's ok thank you very very much
  8. hello i need ask you does dba is the same of sys user or system user ,as when we say that spfile is created by dba what is meaning? i know that spfile is created during oracle installation so how to say that is created by dba?
  9. ok thanks that's right thank you very much
  10. hello I prefer to submit a new topic for benefit that is how to check and verify 10g XE Server Installation and server is running ok via web browser ?
  11. reem-akk

    create index then dropped it how to recover it

    HELLO SIR : thanks for you very much ,you are very nice for rapidly discuss me ,your answer is right and i am very pleased depend you in my problems thanks for god and thanks for you and i hope for you more success
  12. please I am learning oracle and i need help from this pretty site , i create table then create to it index then i drop this index my question how to restore it to my table from recycle bin
×