Aug
07
1.EXPORT:
exp system@test owner=test123 file=d:\oracle\user.dmp log=d:\oracle\userdump.log
rows=y statistics=none feedback=100 indexes=y consistent=y compress=n;
(for individual tables=table1,table2,.....)
2.IMPORT:
imp system@test fromu…
more »
Tags: access, account, add, already, alter, calculate, check, command, connected, control, count, create, creating, database, datafile, datafiles, debug, dropped, end, error, error:ora-00001, export, file, files, get, give, grants, import, include, indexes, information, install, installed, kill, linux, manually, monitoring, object, oc4j_bi_forms, ods.ods_process, os, particular, path, procedure, regarding, report, resize, restart, schema, script, select, server, session, sessions, solaris, space, spfile, spid, status, steps, system, table, tablespace, temp, tempfile, temporary, trace, unix, used, user, username, users, windows
Aug
05
create temporary tablesapce tempfile 'c:\------.dbf' size 200m;
more »
Tags: add, create, oracle, sapce, table, temporary
Aug
05
alter tablespace add datafile 'PATH' size 200m;
more »
Tags: add, adding, datafile, oracle, space, table
XML Feeds
Recent comments