Oracle SQL Developer filter "default tables" [SOLVED]
-
After you install Oracle 11g XE, it will automatically create some tables (from what I've read, some are used for "Application Express", and you shouldn't drop them), but having them listed in Tables view is really annoying. Is there a way to filter them out? And why do you use $ in table name for?
-
After you install Oracle 11g XE, it will automatically create some tables (from what I've read, some are used for "Application Express", and you shouldn't drop them), but having them listed in Tables view is really annoying. Is there a way to filter them out? And why do you use $ in table name for?
Can't help you with the filtering since I don't work with Oracle anymore, but the V$ is just the naming standard Oracle uses for "Volatile" files, containing statistics and such stuff
Wrong is evil and must be defeated. - Jeff Ello
-
Can't help you with the filtering since I don't work with Oracle anymore, but the V$ is just the naming standard Oracle uses for "Volatile" files, containing statistics and such stuff
Wrong is evil and must be defeated. - Jeff Ello
Oh OK, I though they have some special meaning, something that I will have to use in the future too, guess not. Thanks!
-
After you install Oracle 11g XE, it will automatically create some tables (from what I've read, some are used for "Application Express", and you shouldn't drop them), but having them listed in Tables view is really annoying. Is there a way to filter them out? And why do you use $ in table name for?
For some reason, last time I searched on google it didn't showed me anything useful (on any of the first 4 pages), but this time, I got the answer I needed. Solutions: 1. Use a different user then SYSTEM. I didn't though at this, after all I didn't wanted to complicate things on a learning project. 2. Filter each group using %. When I tried it before it didn't worked, but now after I started the DB again, the filter worked as it should have. Maybe there was an error connecting to the DB, don't know, it's good that now it is working.