31. august 2011 - 12:55Der er
6 kommentarer og 1 løsning
Why do I get systemtables from Oracle?
Hello!
I'm playing around with some code that retrive metedata from an oracle.
I have created a tablespace and a user like: DROP TABLESPACE testing INCLUDING CONTENTS AND DATAFILES; CREATE TABLESPACE testing LOGGING DATAFILE 'C:\testing.DBF' SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL;
CREATE USER testing_user IDENTIFIED BY testing_password DEFAULT TABLESPACE testing;
GRANT CREATE SESSION TO testing_user; GRANT CREATE SEQUENCE TO testing_user; GRANT CREATE PROCEDURE TO testing_user; GRANT CREATE TABLE TO testing_user; GRANT CREATE VIEW TO testing_user; GRANT UNLIMITED TABLESPACE TO testing_user;
In this database I got a table like:
DROP TABLE Countries CASCADE CONSTRAINTS; CREATE TABLE Countries ( id INT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY (id) ) TABLESPACE testing;
When I try to fetch the tables like: String[] types = {"TABLE"}; ResultSet resultSet = databaseMetaData.getTables(null, null, "%", types);
At least in the first line I do it like sys (creating the user) could this be something? (But correct me if I'm wrong when I say that I hardly can not create the user since I do not got any other user to use?)
In the second command I use the newly created user to set up the tables.
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.